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


I wrote a very little VBA-Script.
I have a button in a sheet.
When I click this button I want to select the second row in another sheet to freeze it.


This is my script:
Code:
Sub ErsteZeileEinfrieren() '(2)
    'friert die erste Zeile ein
    Worksheets(1).Activate
    Rows("2:2").Select
    ActiveWindow.FreezePanes = True
End Sub
The line "Rows("2:2").Select however does not work.
I get this error (german):

"Laufzeitfehler '1004':
Die Select-Methode des Range-Objektes konnte nicht ausgeführt werden."



Does anybody have any hints?
Reply With Quote