View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mvyvoda mvyvoda is offline
external usenet poster
 
Posts: 41
Default PageBreak in VBA???

I'm trying to set page breaks (via VBA) for a dynamic range (involving
RowStart). Can someone please direct me to what i need the 2nd line statement
to equal. currently it says "SELECTION" because i don't know what to enter.

ActiveSheet.PageSetup.PrintArea = Range(Cells(1, 1), Cells(RowStart - 1,
11)).Select
Set ActiveSheet.HPageBreaks(1).Location = SELECTION

Thanks for your time and energy,
-m