Assuming that is actually his problem, not necessarily. You can certainly
qualify references so Excel doesn't have to guess what they refer to.

--
Regards,
Tom Ogilvy

"David" wrote in message
...
Hi Tom,
Does that mean he has to copy the code out and put it in "general"?

"Tom Ogilvy" wrote:

You probably have the code in a sheet module and when you make
unqualified
references, intending to address the activesheet, those unqualified
references instead refer to the sheet containing the code.

--
Regards,
Tom Ogilvy

"Himszy" wrote in message
. uk...
This is the situation: I have a code which when i run in the debugger
it
works perfect. I set it to run through all at once and it crashes.
Why?