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 |
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/ |
Excel 2000 VBA - Set Print Range in dynamic range
|
All times are GMT +1. The time now is 03:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com