Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
error: Object doesn't support this prop or method... I don't understand..
Public Sub PrintOnly10() 'Rows set (in page setuup) at top to repeat $4:$4 Dim i As Long Dim MyRange As Range Dim MyRange1 As Range Set MyRange = Range("A5").CurrentRegion 'A5 is first row of data Set MyRange1 = MyRange.Offset(1, 0).Resize(MyRange.Rows.Count - 1, 9) With MyRange1 For i = 29 To .Rows.Count Step 10 .HPageBreaks.Add .Cells(i, 1) '<< Getting R/T 438 Next i End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HPageBreaks.Add | Excel Programming | |||
HPageBreaks.Add | Excel Worksheet Functions | |||
More HpageBreaks Strangeness | Excel Programming | |||
Can't set manual HPageBreaks | Excel Programming | |||
Can't set manual HPageBreaks | Excel Programming |