Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
What does XLS VB Method 'Range of object' _Global failed mean?
One of our XLS is suddenly getting the above message and I cannot find what
the cause is or even where to look for a list of common VB error messages. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
What does XLS VB Method 'Range of object' _Global failed mean?
Some VBA code is running and trying to work with a range on the worksheet -
but for whatever reason, it is failing in its task. Perhaps it is using the selection object, expecting the selection to be a range, and something else is selected - such as a chart object. Knowing what the error message means is just a start. You have to find out what code is running and why it is running - then test that code to see where the error occurs -- Regards, Tom Ogilvy "DCMKGG" wrote in message ... One of our XLS is suddenly getting the above message and I cannot find what the cause is or even where to look for a list of common VB error messages. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
What does XLS VB Method 'Range of object' _Global failed mean?
Hi
Check for AddIns installed: Uncheck Addin on by one and close and re-open Excel each time. Next time Excel opens with no error message you will have identified the faulty AddIn. HTH Cordially Pascal "DCMKGG" a écrit dans le message de news: ... One of our XLS is suddenly getting the above message and I cannot find what the cause is or even where to look for a list of common VB error messages. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Method 'Range' of object '_global' failed | Excel Discussion (Misc queries) | |||
runtime error 1004 method range of object '_global failed | Excel Discussion (Misc queries) | |||
<Method 'Range' of object '_Global' failed error | Excel Programming | |||
Method 'Range' of object '_Global' failed | Excel Programming | |||
Method 'Range' of object '_Global' failed | Excel Programming |