View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
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.