View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Remove all manual page breaks

Hi Bking,

Try:

ActiveSheet.HPageBreaks.Add Befo=ActiveCell

---
Regards,
Norman


"Bking" wrote in message
...
I'm looking for help with using a macro to insert page breaks and am
curious
what code you are using to insert page breaks.