searching for characters in a formula

[Luis939]

I was writing a loop which would check to see if the active cell has the formula "=SUM(range)". I thought I would simply say something like

if activecell.value = "=*"

or

if activecell.value = "=SUM(*)"

but apparently I'm either using the wildcard wrong, or i have the wrong syntax, any ideas, thanks!

 

[Luis939]

actually if you were to do a Ctrl+Find But by Formula, and search for "=", it would locate that formula in the cell, so maybe i should use formula or formulaR1C1 instead of value, but its still not working, can anyone tell me the difference between activecell.formula and activecell.formulaR1C1

 

[senators40]

Try this

If ActiveCell.Formula Like "=SUM*" Then

You have to use the Like feature for wildcards.

If you want to check for an =sum anywhere in the formula then do this

If ActiveCell.Formula Like "*=SUM*" Then

The * acts as a wildcard before and after the cell

Hope it helps

Jeff