Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 110
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Method 'Range' of object '_global' failed higherlimits Excel Discussion (Misc queries) 3 June 23rd 06 06:16 PM
runtime error 1004 method range of object '_global failed valdesd Excel Discussion (Misc queries) 2 October 6th 05 07:26 PM
<Method 'Range' of object '_Global' failed error Ken Loomis Excel Programming 2 October 12th 04 01:29 PM
Method 'Range' of object '_Global' failed Brian Morris[_2_] Excel Programming 1 December 10th 03 11:04 PM
Method 'Range' of object '_Global' failed Mohanasundaram[_2_] Excel Programming 1 August 25th 03 01:43 PM


All times are GMT +1. The time now is 06:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"