Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run time error '438'. Object doesn't support this property or meth
I am having great difficulty referencing other workbooks and their worksheet
data from a macro in the Personal Workbook (PERSONAL.XLSB). For example, the following instruction should be, but does not seem to be supported when it occurs in a macro in my Personal Workbook, Personal.xlsb: RowIndex = Workbooks("BookDates1.xlsm").Range("A19"). The following instruction is not supported either: RowIndex = Workbooks("BookDates1.xlsm").cells(19, 1). (RowIndex is defined as: "Dim RowIndex As Long" near the top of the Sub Procedure.) Both of these give the error message: "Run time error '438'. Object doesn't support this property or method. My email address is . Thank you very much. Sincerely, Michael D Fitzpatrick -- May you have a most blessed day! Sincerely, Michael Fitzpatrick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Object doesn't support this property or method (Error 438) | Excel Programming | |||
Run-time error '438': Object doesn't support this property of meth | Excel Programming | |||
help with my code please. (Error: Object doesn't support this property or method) | Excel Programming | |||
Object doesn't support this property or method (Error 438) | Excel Discussion (Misc queries) | |||
Run Time Error 438 - Object doesn't support the property or method | Excel Programming |