Conditional page break position

%3CLINGO-SUB%20id%3D%22lingo-sub-2055076%22%20slang%3D%22en-US%22%3EConditional%20page%20break%20position%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2055076%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20set%20page%20breaks%20in%20Excel%20to%20automatically%20adjust%20to%20a%20specific%20row%2Fcolumn%20depending%20on%20which%20rows%2Fcolumns%20are%20visible%20(so%20not%20hidden)%20at%20the%20time%3F%20I%20cannot%20seem%20to%20make%20this%20work.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20over%20300%20rows%20of%20data%2C%20and%20VBA%20code%20that%20hides%20none%20relevant%20rows%20each%20time%20data%20is%20entered.%20However%20I%20then%20need%20to%20manually%20adjust%20the%20page%20breaks%20if%20I%20need%20to%20save%20as%20a%20PDF%20or%20print%2C%20and%20I'm%20just%20trying%20to%20automate%20that%20process%20if%20possible.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'd%20rather%20not%20write%20more%20VBA%20code%20if%20I%20don%3Bt%20have%20to%2C%20so%20just%20reaching%20out%20to%20the%20community%20for%20any%20expertise%20%2F%20tips%20please.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2055076%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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