Paul

Post the code.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Paul" wrote in message
...
Hi-

I wrote a macro that includes a line of code that select a
sheet in the format Sheets("Sheetname").select. It worked
fine for a few weeks but all of a sudden VB started
breaking on that line of code with the run-time error
40036 message "Application defined or object defined
error". The sheet has not been renamed and is still
present. Is this a bug or can it be fixed?

Thanks,

Paul