test cell to see that is does not use a certain function

[dgillz]

In VBA, how can I test a cell's formula to see if it does or does not contain a certain function?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[SkipVought]

Hi,

Check the Formula property.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[AnotherHiggins]

You could just use InStr to see if the function is in the formula:

    If InStr(Range("A1").Formula, "SUM") Then
        MsgBox "YES"
    End If

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.