Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 VBA - Set Print Range in dynamic range
Thanks, Tom, the last one was perfect. Now I need to print that. Hav
tried the following: Range("A1", Cells(rwIndex, 5)).Select worked great to select teh Range but... ActiveSheet.PageSetup.PrintArea = Range("A1", Cells(rwIndex, 5)) errors out and ActiveSheet.PageSetup.PrintArea = RangeSelection doesn't error bu doesn't work either. Thanks, Mar -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Dynamic Range | Excel Discussion (Misc queries) | |||
How do I make a dynamic print range in excel? | Excel Discussion (Misc queries) | |||
how to change range for dynamic chart in excel 2000 with button? | Charts and Charting in Excel | |||
Dynamic Print Range Help | Excel Worksheet Functions | |||
Dynamic Print Range | Excel Programming |