Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting printarea through range object
Hi,
I have a worksheet in which I have hidden all of the empty rows. Now want to print the visible rows, but I don't seem to be able to. I prefer selecting the rows and storing them in a range object, afte which I can set the range object as the printarea. Can this be done an if so, what code should I use? Yours truly, Berend Botj -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Setting PrintArea by using Named Ranges | Excel Programming | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming |