Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple? View named range from sheet1 on sheet2 | Excel Worksheet Functions | |||
how can i view the range of 75% of a column | Excel Worksheet Functions | |||
View and Cell Sum Range | Excel Discussion (Misc queries) | |||
limit worksheet view to specified cell range | Setting up and Configuration of Excel | |||
Copy range without changing sheet in view? | Excel Programming |