VBA Excel if Cell Is Not Equal to formula then
<p>I want to check if a cell is this formula then execute a part 2 script</p>

<p>The code Simplified</p>

<pre><code>Range("B1:C1").Select
If ActiveSheet.Name = "Sheet1" And ActiveCell &lt;&gt; "=formula1" Then Sheet1Macro
</code></pre>

<p>the complete code (long)</p>

<pre><code>Range("B1:C1").Select
If ActiveSheet.Name = "Sheet1" And ActiveCell &lt;&gt; "=IF(OR(IFERROR(SEARCH(""DKB"",RC[-2]),0),IFERROR(SEARCH(""Cox"",RC[-2]),0),IFERROR(SEARCH(""2020"",RC[-2]),0)),RC[-1],"""")" Then Sheet1Macro
</code></pre>

<p>I'm just asking on how to check if the cell is a formula because I insert rows and that changes the formula from A2:F99 to A99:F189 for example</p>