Ed,

'1004' is a very generic error condition that simply means
"something went wrong". It arises in dozens of circumstances.
Perhaps you could post the problematic code and identify what
line of code is causing the error.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Ed" wrote in message
...
I've tried looking this up in the NG and the KB to see if I
could pin it
down, but it seems to be a chameleon, giving a different
message depending
on the circumstances. So what error is it actually detecting?
(I was doing
a Find through each worksheet. Some sheets had an exact match,
some had a
partial match, some had no match. A match gave err.number=0,
no match was
91. What would the 1004 be trying to tell me?)

Ed