Thread: [Solved] Select a row in a different tab
View Single Post
 
Old 07-09-2018, 02:47 AM
cosmicyes cosmicyes is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Jan 2018
Posts: 8
cosmicyes is on a distinguished road
Default
ooops... got it


Code:
Sub ErsteZeileEinfrieren() '(2)
    'friert die erste Zeile ein
    Worksheets(1).Activate
    Application.Sheets(1).Rows("2:2").Select
    ActiveWindow.FreezePanes = True
End Sub

I thought I tried this before...
Reply With Quote