Setting print range using VBA
You could set it to the used range every time:
ActiveSheet.PageSetup.PrintArea = _ ActiveSheet.UsedRange.Address HTH... -----Original 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 . |
All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com