#1
|
|||
|
|||
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 I get this error (german): "Laufzeitfehler '1004': Die Select-Methode des Range-Objektes konnte nicht ausgeführt werden." Does anybody have any hints? |
#2
|
|||
|
|||
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... |
Tags |
select row freeze |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Select pasted | ArtKilp | Word | 2 | 08-10-2017 07:23 AM |
Cant select shape! Please help! | Philosofen | Word | 1 | 03-07-2017 07:03 AM |
How to select row | aymanharake | Excel Programming | 3 | 02-18-2017 04:09 PM |
How to select different words at once | FTL | Word | 5 | 03-08-2016 06:10 PM |
select all tables | majed_m | Word VBA | 5 | 07-30-2015 03:29 AM |