| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Screen scrolling to show active cell
In VBA code, when I activate or select a cell outside the visible screen
area, the cell is set but the screen is not scrolled to the active cell to show it. I have not been able to find any command that will bring the active cell into view. If my screen shows rows 1-20 and columns A-P and the active cell is A1, and I execute code Range("AZ302").Select or Range("AZ302").Activate, my screen still shows rows 1-20, columns A-P, cell A1 is not active, cell AZ302 is active. How do I get the active cell to be in the visible portion of the screen? -- WEW |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Screen scrolling to show active cell
You are going to kick yourself...
Activecell.Show -- HTH... Jim Thomlinson "AlForester" wrote: In VBA code, when I activate or select a cell outside the visible screen area, the cell is set but the screen is not scrolled to the active cell to show it. I have not been able to find any command that will bring the active cell into view. If my screen shows rows 1-20 and columns A-P and the active cell is A1, and I execute code Range("AZ302").Select or Range("AZ302").Activate, my screen still shows rows 1-20, columns A-P, cell A1 is not active, cell AZ302 is active. How do I get the active cell to be in the visible portion of the screen? -- WEW |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Screen scrolling to show active cell
Thanks. Yes, some tasks are easier than expected.
-- WEW "Jim Thomlinson" wrote: You are going to kick yourself... Activecell.Show -- HTH... Jim Thomlinson "AlForester" wrote: In VBA code, when I activate or select a cell outside the visible screen area, the cell is set but the screen is not scrolled to the active cell to show it. I have not been able to find any command that will bring the active cell into view. If my screen shows rows 1-20 and columns A-P and the active cell is A1, and I execute code Range("AZ302").Select or Range("AZ302").Activate, my screen still shows rows 1-20, columns A-P, cell A1 is not active, cell AZ302 is active. How do I get the active cell to be in the visible portion of the screen? -- WEW |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying active cell in particular position on screen | Excel Programming | |||
| Screen does not scroll as active cell moves down the page | Excel Discussion (Misc queries) | |||
| how do I keep the active cell or row in the middle of the screen | Excel Discussion (Misc queries) | |||
| Active cell moves off the screen | Excel Discussion (Misc queries) | |||
| Moving the Active cell to the left of the screen | Excel Programming | |||
Linear Mode
