Your code works fine, but would any ideas here help?
Sub Demo()
Dim aRow As Range
With Range("A1:L97")
For Each aRow In .EntireRow.Rows
Select Case aRow.PageBreak
Case xlAutomatic
Debug.Print "Automatic pgbreak at Row: " & aRow.Row
Case xlPageBreakManual
Debug.Print "Manual pgbreak at Row: " & aRow.Row
End Select
Next aRow
End With
End Sub
--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =
"Rich" wrote in message
...
OK! That help file did the trick. Now this makes sense.
I am just curious why Microsoft isn't including these help
files with the later versions of Excel if that older
functionality is still available. There must a way to do
the same thing with pagebreaks for named ranges in the
later version - without having to look at EntireRow or
EntireColumn. Oh well, at least I have some solutions
now.
Thank you all for your help.
Rich
-----Original Message-----
If you are interested, the old Excel 4 macro help file is
still available
for download from Microsoft.
Macrofun.exe File Available on Online Services
http://support.microsoft.com/default.aspx?scid=kb;en-
us;128185&Product=xlw
--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =
RefersToR1C1:="=GET.DOCUMENT(64,""Sheet1"")"
What does the 64 represent? The number of rows?
It was this line -- "=GET.DOCUMENT(64,""Sheet1"")" --
which really stumped me. I could not find any
documentation on Get.Document(64,""...""). I would be
grateful if someone could explain to me about
Get.Document
(in Excel in this example) or point me to an article or
some source.
.