| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 VBA - Set Print Range in dynamic range
Hi
try ActiveSheet.PageSetup.PrintArea = Range("A1", Cells(rwIndex, 5)).address -- Regards Frank Kabel Frankfurt, Germany Thanks, Tom, the last one was perfect. Now I need to print that. Have 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 but doesn't work either. Thanks, Marc --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 VBA - Set Print Range in dynamic range
|
| Reply |
| 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 | |||
![sub_pop[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
