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
Set FoundCell = DestinationSheet8.Cells.Range("A:A").Find(What:=Combination, _
       LookIn:=xlValues, _
       LookAt:=xlWhole, _
       SearchOrder:=xlByRows, _
       SearchDirection:=xlNext, _
       MatchCase:=False)

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