Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm getting the error message below from VBA from the following code on Line
2 Debug.Print ActiveWorkbook.Name Debug.Print ActiveWorkbook.ActiveSheet Run-time error '-2147319765 (8002802b)' Automation Error Element not found. I added ActiveWorkbook as a Watch Expression in the Watch window, and I can click on the + and I can see an entry as a child record for ActiveSheet. I can click on the ActiveSheet entry and see the name of the ActiveSheet. The element clearly is there in the Watch Window but not seen in the program. Why is VB telling me the Automation Object can't be found? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error message in my Excel sheet | Excel Worksheet Functions | |||
copy sheet error message | New Users to Excel | |||
Active X Error message | Excel Discussion (Misc queries) | |||
Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
Error message with protected sheet | Excel Discussion (Misc queries) |