VBA showing a specific range on the screen
 

I know the row and column of a cell I want to display.
In VBA how do I get Excel to show the cell so identified in the middle of
the screen.
I know it's simple, but searching the help system doesn't give me the answer!
Thanks.

VBA showing a specific range on the screen
 

See the Centering The Screen On A Cell section at
http://www.cpearson.com/excel/zoom.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"jmike210" wrote in message
...
I know the row and column of a cell I want to display.
In VBA how do I get Excel to show the cell so identified in the
middle of
the screen.
I know it's simple, but searching the help system doesn't give
me the answer!
Thanks.