control scroll position

[GUS]

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 )

 

[Chip Pearson]

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 (e-mail address removed)