Runtime Error '13' - Type Mismatch
Posted on 2006-05-05
Okay. Probably another oversight on my part that I'm just not seeing, and I'm not having much luck finding something online that's already been asked.
I get the error on this line:
If Range(sAeLook & iRow).Value = "TRUE" Then
Where sAeLook is a string = "I" and iRow is INT = 3
Column "I3" has the formula:
=IF((VLOOKUP(G2, $L:$L,1,FALSE)=G2), TRUE(), FALSE())
I've also tried pasting the values of the formula over the formula, makeing I3 = "TRUE" or "#N/A" and I still get the error. The thing that confuses me is that I have this very same construction in other macro sheets referring to a string in the sheet with no complications.
I also get the same error when I try:
MsgBox "Cell I3 = " & Range(sAeLook & iRow).Value