using Evaluate on a Name object?
 

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...85&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.

using Evaluate on a Name object?
 

Thanks. I will give that a try.


-----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.



.

using Evaluate on a Name object?
 

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.



.

using Evaluate on a Name object?
 

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.



.