View range in a macro
 

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

--
Message posted from http://www.ExcelForum.com

View range in a macro
 

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

--

Vasant

"grin2000 " wrote in message
...
I would like to know how to set up a "view" for a certain range of cells
that when I click a button which sends me to that certain view that
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 wanted
to know how to format the view to have it fit nicely on one page even
if one's larger than the other. I really appreciate the help.


---
Message posted from http://www.ExcelForum.com/