I am using the Find method to search for the N() function in a cell. It
works fine, except it also picks up any other function that ends with an N
such as:Median, Mean, etc. The same thing happens with I search for the T()
function as well. It picks up SUMPRODUCT, OFFSET etc.

How can I revised the search terms in the Find Method to ensure that I only
get N()? Can I employ wildcards in the search term?


VolFormType = "N"
SpecFormula = VolFormType & "("
With rng
Set C = .Find(SpecFormula, LookIn:=xlFormulas)
If Not C Is Nothing Then
HasSpecificFormula = True
End If
End With