Gates Is Antichrist
Well-known Member
- Joined
- Aug 15, 2002
- Messages
- 1,961
This is likely Y.A. pathetically useless/misleading/incorrect error message. Anyone know what the real problem might be? XL03 on XP.
Run-time error '13':
Type Mismatch
ActiveCell is a single cell on an unhidden sheet - cell A279.
I can Control-F at this point in Excel, and it finds "LIQ" just fine.
Now here comes the queer part. At least at THIS moment, if activecell is on rows 1 through 26, NO PROBLEM. If it's on rows 28+, death message shown above. J27 is the point where death begins. I've cleared i27:k27 and there's nothing notable there. L279 is the end of UsedRange.
Since this clearly is a bug, I'll really reach far now: there is a "drawing symbol" (a big "right brace") that begins at J34, if that's a clue. (I'm mystified as to what worksheet cells are connected to big drawing symbols like this.)
If anyone recognizes this and can "succint-ize" it down to a simple reproducible example, that would be useful too, if we need to go to Usenet on this.
Thanks.
Run-time error '13':
Type Mismatch
Code:
dim c as Range
...
Set c = .Find(what:="LIQ", _
LookIn:=xlFormulas, _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
After:=ActiveCell, _
MatchCase:=False)
I can Control-F at this point in Excel, and it finds "LIQ" just fine.
Now here comes the queer part. At least at THIS moment, if activecell is on rows 1 through 26, NO PROBLEM. If it's on rows 28+, death message shown above. J27 is the point where death begins. I've cleared i27:k27 and there's nothing notable there. L279 is the end of UsedRange.
Since this clearly is a bug, I'll really reach far now: there is a "drawing symbol" (a big "right brace") that begins at J34, if that's a clue. (I'm mystified as to what worksheet cells are connected to big drawing symbols like this.)
If anyone recognizes this and can "succint-ize" it down to a simple reproducible example, that would be useful too, if we need to go to Usenet on this.
Thanks.