macro to set page break before empty cell

[jdvdh001]

Hi
I need a macro to insert a page break before each empty cell in column k. The print range is from a14 down. There are empty rows after each change in data which will have a page break.

Thanks

[JasperD]

How about something like this ?

Please Login or Register  to view this content.

Please click the * below if this helps

[jdvdh001]

I get a error on this line
HPageBreaks.Add Before:=cell

[HaHoBe]

Hi, jdvdh001,

imaybe it should read ActiveSheet.HPageBreaks.Add Before:=cell.

Please Login or Register  to view this content.

Ciao,
Holger