control scroll position
 

Is it possible to control th scroll to right position until a specified cell
comes to the center of the screen.(with vba of course)

Lets say i want with the press of a button to bring in the center of the
screen the column (z) or with another button the column (AV) etc.
(anywhere inside the screen area not )

control scroll position
 

Gus,

See the "Zoom And Center" page on my web site
www.cpearson.com/excel/zoom.htm .


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



"GUS" wrote in message
...
Is it possible to control th scroll to right position until a
specified cell
comes to the center of the screen.(with vba of course)

Lets say i want with the press of a button to bring in the
center of the
screen the column (z) or with another button the column (AV)
etc.
(anywhere inside the screen area not )