Runtime Error '13' - Type Mismatch

Posted on 2006-05-05
Medium Priority
Last Modified: 2010-05-01
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:

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?
Question by:Vriaeliss
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 600 total points
ID: 16614997
If cbool(Range(sAeLook & iRow).Value) = TRUE Then

Author Comment

ID: 16615021
Thanks. That works ^_^

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question