View range in a macro

G

grin2000

I would like to know how to set up a "view" for a certain range of cell
that when I click a button which sends me to that certain view tha
that will be the only thing seen on the screen and when I print it out
nothing else. Some of the views aren't as big as others and I wante
to know how to format the view to have it fit nicely on one page eve
if one's larger than the other. I really appreciate the help
 
V

Vasant Nanavati

Selecting the range and setting ActiveWindow.Zoom to True will zoom into the
selection and fill the screen to the extent possible.
 
Top