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.