View Full Version : Solved: Select the Second visible cell in A column
Djblois
08-08-2006, 07:11 AM
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
08-08-2006, 08:35 AM
Try this Daniel...
ActiveWindow.Panes(3).Activate
Range("A1").Select
Zack Barresse
08-08-2006, 09:16 AM
Check out the ScrollRow property of the Activewindow object ...
ActiveWindow.ScrollRow = 1
HTH
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.