willow1985
Well-known Member
- Joined
- Jul 24, 2019
- Messages
- 931
- Office Version
- 365
- Platform
- Windows
Hello,
I was just wondering what would be the code to adjust a print area down 1 row without using specific ranges?
I currently have a macro that finds the end of a table and adds a row for new data however I would like to expand the print area after I add the row by 1 row.
the only code I know is: ActiveSheet.PageSetup.PrintArea = "your range"
Any help would be appreciated.
Thank you
Carla
I was just wondering what would be the code to adjust a print area down 1 row without using specific ranges?
I currently have a macro that finds the end of a table and adds a row for new data however I would like to expand the print area after I add the row by 1 row.
the only code I know is: ActiveSheet.PageSetup.PrintArea = "your range"
Any help would be appreciated.
Thank you

Carla