View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default 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.