<div>
the code I am using is very complicated, I just threw in that one line<br />
<br />
The reason I am using evaluate is because I have a variable that is equal to:<br />
=<br />
&lt;&gt;&nbsp;<br />
&gt;<br />
&lt;<br />
and the only way to use those is with evaluate.<br />

</div>


the code I am using is very complicated, I just threw in that one line

The reason I am using evaluate is because I have a variable that is equal to:
=
<> 
>
<
and the only way to use those is with evaluate.


<div>
nevermind, you are correct. thanks
</div>


<div>
If you have an operator, as in your earlier question, you do not need the Chr(34) at all. This is because you are concatenating several values, and the result is a string. Putting that string inside double quotes then causes an error because the double quotes aren't required.
</div>


If you have an operator, as in your earlier question, you do not need the Chr(34) at all. This is because you are concatenating several values, and the result is a string. Putting that string inside double quotes then causes an error because the double quotes aren't required.

<div>
FYI, you only needed the CHR(34) before because you were comparing text strings (&quot;M&quot;=&quot;M&quot; is true, but M=M makes Excel think M is a variable of some kind). Here you are are comparing numbers, so you wouldn't need the CHR(34).<br />
Regards,<br />
Rory
</div>


FYI, you only needed the CHR(34) before because you were comparing text strings ("M"="M" is true, but M=M makes Excel think M is a variable of some kind). Here you are are comparing numbers, so you wouldn't need the CHR(34).
Regards,
Rory

<div>
<div class="content wysiwyg-content">
This statement below is true, but it is not recognizing it as true. I assume it is because I need to put the Chr(34) somewhere but I do not know where I need to. Can you help me?<br />
<br />
If Application.Evaluate(Chr(3<wbr />4) &amp;&nbsp;InStr(r.Offset(0, VarA1).Value, VarC1) &gt;&nbsp;0 &amp;&nbsp;Chr(34)) Then run code a<br />
<br />

</div>
</div>


This statement below is true, but it is not recognizing it as true. I assume it is because I need to put the Chr(34) somewhere but I do not know where I need to. Can you help me?

If Application.Evaluate(Chr(34) & InStr(r.Offset(0, VarA1).Value, VarC1) > 0 & Chr(34)) Then run code a



Evaluate Function and Chr(34) in excel vba

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.