Assigning a Page Break Value

[Bowser1966]

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

 

[plettieri]

Hello Browser1966

Welcome to the board

Have you tried naming your range to print,,,ie "printarea" so that your print area will be adjusted automatically each time you have an insert or deletion of a column or row?

Once you named you range add it to your macro.

Hope this helps.
pll

 

[Bowser1966]

Well, thats my problem I want the new rows to be added to the print area but I want the print area to be fixed at a specific column Such as P.
This message was edited by Bowser1966 on 2002-10-08 15:25
This message was edited by Bowser1966 on 2002-10-08 19:37