Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting print range using VBA
If there is no Print range set then the usedrange is printed if you press the print button.
You can use this for example if the prinrrange is set but is not all the cells on the sheet. ActiveSheet.UsedRange.PrintOut -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Gary" <gary.coons@swelectric wrote in message ... I am looking for an easy way to use a macro to select a print range by determining the last row and column used. However, the last row and column used will change between users. For example, if the user only used up to row 98 and column L is the last column used. I need to select the range A1 to L98 and print this range. Thanks for any input. gary |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting The Print-Area ? | New Users to Excel | |||
Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
Excel Addin:Setting the range to the Excel.Range object range prop | Excel Worksheet Functions | |||
Setting Print range | Excel Programming | |||
Value of Zoom print setting | Excel Programming |