| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Positioning a cell at the top left of the screen
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Positioning a cell at the top left of the screen
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 "Ben" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Positioning a cell at the top left of the screen
Hi Ben,
Try these: ActiveWindow.ScrollRow = 3 ActiveWindow.ScrollColumn = 3 Best Regards, Walt Weber "Ben" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Positioning a cell at the top left of the screen
Oops! That should be:
ActiveWindow.ScrollRow = Activecell.Row ActiveWindow.ScrollColumn = Activecell.Column Best Regards, Walt Weber "Walt" wrote: Hi Ben, Try these: ActiveWindow.ScrollRow = 3 ActiveWindow.ScrollColumn = 3 Best Regards, Walt Weber "Ben" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Positioning a cell at the top left of the screen
One way...
Application.Goto ActiveCell, True HTH :) -- Dana DeLouis Win XP & Office 2003 "Ben" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can i put sheets on the left and right of my screen | Excel Discussion (Misc queries) | |||
| Hyperlink Destination Positioning On Screen | Excel Worksheet Functions | |||
| Scroll a cell to the top left hand corner of the screen | Excel Discussion (Misc queries) | |||
| Move Cell to Top/Left Position on Screen | Excel Programming | |||
| Moving the Active cell to the left of the screen | Excel Programming | |||
Linear Mode
