Conditional page break position

Occasional Visitor

Hi

 

Is it possible to set page breaks in Excel to automatically adjust to a specific row/column depending on which rows/columns are visible (so not hidden) at the time? I cannot seem to make this work. 

 

I have a spreadsheet with over 300 rows of data, and VBA code that hides none relevant rows each time data is entered. However I then need to manually adjust the page breaks if I need to save as a PDF or print, and I'm just trying to automate that process if possible. 

 

I'd rather not write more VBA code if I don;t have to, so just reaching out to the community for any expertise / tips please. 

 

Thanks

0 Replies