Select a row in a different tab

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Select a row in a different tab

FAQ

Thread Tools

Display Modes

07-09-2018, 02:47 AM

cosmicyes

Windows 7 64bit Select a row in a different tab

Office 2013

Novice

Join Date: Jan 2018

Posts: 8

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:54 PM.