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