Select a row in a different tab

cosmicyes · #1 07-09-2018, 02:31 AM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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