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

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

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