Positioning a cell at the top left of the screen

[Guest]

Hello,
Is there a way of selecting a cell and ensuring that the selected cell is
always at the top left of the screen?
Thank you

 

[Bob Flanagan]

You could do

Application.goto activecell, true
activecell.offset(1,1).select
activewindow.freezepanes = true

Bob Flanagan
Macro Systems
Delaware, U.S. 302-234-9857
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Guest]

Hi Ben,

Try these:
ActiveWindow.ScrollRow = 3
ActiveWindow.ScrollColumn = 3

Best Regards,
Walt Weber

 

[Guest]

Oops! That should be:

ActiveWindow.ScrollRow = Activecell.Row
ActiveWindow.ScrollColumn = Activecell.Column

Best Regards,
Walt Weber

 

[Dana DeLouis]

One way...

Application.Goto ActiveCell, True

HTH :>)