Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Label Options - Forms Object vs Control Box Object | Excel Discussion (Misc queries) | |||
Object Variable Not Set Error on Selection object | Excel Worksheet Functions | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming | |||
Range object to Array object conversion | Excel Programming |