A Pretty Easy One....

  • Thread starter Thread starter Randy Numbers
  • Start date Start date
R

Randy Numbers

....if you know this stuff...


How can I build a RANGE reference? I do a search and find the row I want is
RNDX; now I want to insert a pagebreak:


.HPageBreaks.Add.Range("A",RNDX) ???????


Thanks./R
 
One way:

.HPageBreaks.Add .Range("A" & RNDX)

or, use Cells() instead:

.HPageBreaks.Add .Range(RNDX,1)
 
Back
Top