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?