Runtime Error '13' - Type Mismatch

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

Any ideas?
VriaelissAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
If cbool(Range(sAeLook & iRow).Value) = TRUE Then
0
 
VriaelissAuthor Commented:
Thanks. That works ^_^
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.