View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Zoom a range without actually selecting it

for my PC, I had to use zoom at 180%.

--
Regards,
Tom Ogilvy


"Leith Ross" wrote
in message ...

Hello Jim,

This code example will zoom the ActiveWindow and move column "G" to the
left. The top row shown is row 10. On my screeen I used a zoom of 150%
to get columns "G" to "M" to fill the width of the screen. This is done
without selecting the columns first.

With ActiveWindow
Zoom = 150
ScrollColumn = 7
ScrollRow = 10
End With


Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:

http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=514168