Run time error 13 Type Mismatch pointing to Find MatchCase=false

Hello,

I received the error in the thread from a macro. However, I've run this macro several times before with no error.

This is the block of code the debugger has highlighted

Please Login or Register  to view this content.

FoundCell is a range
DestinationSheet8 is a worksheet
Combination is a String

I have code setup to handle if the find fails or if it succeeds. But in this instance it seems like the find just doesn't want to work.

When I step into the worksheet and hit ctrl+f and then enter. Nothing seems to happen, it doesn't tell me that it can't find it, but it doesn't select the correct cell either.

Any ideas? Tell me if you need more information.

Thanks,
NukedWhale

Are there any known issues or limits with excel 2007/VBA as it relates to string length or string length as it relates to find?

Source of the problem identified.

I think this is the cause:

In Microsoft Excel 7.0 or earlier, this behavior occurs because the character limit per cell is 255 characters. As a result, strings greater than 255 characters in length that are passed from a Visual Basic procedure to any Microsoft Excel function or object are truncated to 255 characters.

In Excel, you can use more than 255 characters in a cell; however, when you pass strings that are greater than 255 characters in length from a Visual Basic procedure, Excel uses the same design that earlier versions use.

This limit applies to all strings that you pass from a Visual Basic procedure to an Excel sheet; it is not exclusive to information you pass to cells. For example, if you pass a text string that is longer than 255 characters to a text box on a worksheet or a dialog sheet, Excel truncates the text even though a text box can hold up to 10,240 characters.

http://support.microsoft.com/kb/213841