Range and Find function error: Type Mismatch

**VBNewb** · 07-07-2011, 11:38 AM

Hey guys,

Im not too familar with using range functions, but I'm trying to debug a few macros that has this. When I step through the macro, as I get to the second rFroundCell, where it looks for the string: findStr, I get this error: "type mismatch"

Does this mean that the numbers or strings are not the same? Possibly different cell properties? I've looked into the sheet itself and its just word. I'm sure I am over looking something simple. What do you guys think?

thank you so much!

Please Login or Register  to view this content.

**StephenR** · 07-07-2011, 11:49 AM

The cell specified in the After parameter (U1) must be in the range being searched, but that appears to be column 1. Why did you specify U1?

**snb** · 07-07-2011, 12:19 PM

why not

Please Login or Register  to view this content.

**VBNewb** · 07-07-2011, 02:10 PM

thank you snb. I tried that before reading this post and it worked. I feel stupid hahah *smh

Range and Find function error: Type Mismatch

LinkBack

Thread Tools

Rate This Thread

Display

Range and Find function error: Type Mismatch

Re: Range and Find function error: Type Mismatch

Re: Range and Find function error: Type Mismatch

Re: Range and Find function error: Type Mismatch

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions