zombiemaster
Board Regular
- Joined
- Oct 27, 2009
- Messages
- 241
I know about endRow$ = ActiveCell.Row but is there a similar way to find the last column the same way? I tried versions of EndColumn$ = ActiveCell.Column but it didn't seem to work...
What I'm trying to do is set the print area for the entire range of data on a worksheet but the number of rows and columns can change from day to day. When I run the report each day, I have to go in and manually drag the print area over to encompass all the columns.
Thanks for any help!
~ZM~
What I'm trying to do is set the print area for the entire range of data on a worksheet but the number of rows and columns can change from day to day. When I run the report each day, I have to go in and manually drag the print area over to encompass all the columns.
Thanks for any help!
~ZM~