Bowser1966
New Member
- Joined
- Oct 6, 2002
- Messages
- 2
Is there a way to set a page break value from a value in a cell on a worksheet. For example if cell A5 has a value fo 22 in it I want to set my page break with that value.
For example:
ActiveSheet.PageSetup.PrintArea = "$A$1:$N$35"
I would like to set my value of 35 to the value in cell A5 of 22.
The reason I need a value of a cell is because there is a formula to count the rows which is constantly changing, and when Im ready to print the page break has to be set correctly to the value in A5.
Any suggestions would be appreciated
For example:
ActiveSheet.PageSetup.PrintArea = "$A$1:$N$35"
I would like to set my value of 35 to the value in cell A5 of 22.
The reason I need a value of a cell is because there is a formula to count the rows which is constantly changing, and when Im ready to print the page break has to be set correctly to the value in A5.
Any suggestions would be appreciated