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

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

Hi
best to post your code. I would assume no match was found at all. Use on
error resume next to deal with such errors.

"Ed" wrote:

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

Thanks, Chip. I had the error worked around already. I was mainly asking
for my own information, thinking it might have meant something specific I
should deal with. However, since this *IS* MS, I should have known better.

Ed

"Chip Pearson" wrote in message
...
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