Solved: Select the Second visible cell in A column

[Djblois]

Is this possible??? I just created a macro with help from people here to hide rows under certain conditions. Then I want it to go to the top of the spreadsheet. Selecting A1 will not work because I have on Freeze panes and if it is at the bottom of the worksheet it will still be at the bottom with A1 selected

[lucas]

Try this Daniel...

ActiveWindow.Panes(3).Activate
Range("A1").Select

[Zack Barresse]

Check out the ScrollRow property of the Activewindow object ...

ActiveWindow.ScrollRow = 1

HTH