Re: Remove all manual page breaks

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Bking,

Try:

ActiveSheet.HPageBreaks.Add Before:=ActiveCell

---
Regards,
Norman


"Bking" <Bking@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B3D3A8ED-18E9-4D2E-B6A8-389D3A4CE5EB@xxxxxxxxxxxxxxxx
> 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.
>


.

Relevant Pages

  • Re: Insert cell anywhere
    ... Thanks for replying again, I pasted your suggestion into my macro, it worked ... Regards J. ... "Norman Jones" wrote: ... > Sub Tester04() ...
    (microsoft.public.excel.programming)
  • Re: Copy row if....
    ... > doesn't that carry an implicit negative connotation to it? ... Regards, ... Norman ... >>> I hv one further question regarding macro, is there a website on macro ...
    (microsoft.public.excel.programming)
  • Re: macro -find all occurences of a word-change color of cell of all
    ... Regards, ... Norman ... > I need a macro to find all occurences of the word "Count" in Column B, ...
    (microsoft.public.excel.programming)
  • Re: Fill Color Rows of Varying Size
    ... Regards, ... Norman ... > I was wondering if any of you would know how to do this using a macro. ... > data spans between columns A-J (which means I would need to Fill Color ...
    (microsoft.public.excel.programming)
  • Re: Macro/Security Warning
    ... Regards, ... Norman ... > I've deleted the macro in my workbook, but continue to get the message ...
    (microsoft.public.excel.misc)