Excel

Hi All:
How can I set a pagebreak on a date value programmically in vb for an excel file?

Thanks:wave:

Probably just loop through that column evaluating the cell date
value and if it meets whatever date value criteria then run
something like this code.

Just set the active cell where you want the page break.

VB Code:

ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell

HTH

Thanks RobDog888:thumb:

No prob.