I need to set a print area that adjusts with row deletion

[pueblorox]

I have a VBA macro that dependent on user input goes down column A and deletes certain rows that do not apply to the user selection. However I need to be able to set the print area so that it does not cut off certain information no matter what or how many rows are deleted. I was thinking of putting a p1 at the beginning and end of each page and trying to set print area to those variables, p2 to p2 for page two and so on.. this is a 25 page worksheet..

[royUK]

Set the PrintArea when the code has finished within your code. Without seeing the layout you could maybe use CurrentRegion or UsedRange