Prev: Excel 2007: Selection windows slows down when highlighting cel
Next: Printing makes window inactive
From: מיכאל (מיקי) אבידן on 13 Feb 2010 04:25
I'm not sure I made myself clear enough...
What I meant was:
* Type all the row numbers - where you want the Page-Break - into a range of
adjacent cells.
[If you need 25 page breaks - type the 25 row numbers into 25 cells - like:
F1:F25 or any other range].
* Select those 25 cells and run the Macro.
Micky


"מיכאל (מיקי) אבידן" wrote:

> 1) Type all row numbers where you want to declare Page-Break.
> 2) Copy/Paste the following macro to the VB Editor.
> 3) Select the range of cells and run that Macro.
> ---------------------------------------
> Sub AddPageBreaks()
> For Each CL In Selection
> Cells(CL + 1, 1).Select
> ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell
> Next
> [A1].select
> End Sub
> -------------------
> Micky
>
>
> "Stacy" wrote:
>
> > I need to place bage breaks in specific places on a sheet that has 25,000
> > lines. Is there an easy way to do this?
 | 
Pages: 1
Prev: Excel 2007: Selection windows slows down when highlighting cel
Next: Printing makes window inactive