Hello!

How Can I check whether a specific function is used in a workbook?

for eg: SUM is used in any sheets of the Active Workbook?

So that I can have
if used
do this
else
do this

Thanks

Use the Edit=Find looking in formulas.
You would have to then make sure the found cells use only Sum, not something
like SumProduct

Turn on the macro recorder while you do it manually to get the basic code.
Loop through each sheet.

--
Regards,
Tom Ogilvy



"Saniya" wrote in message
oups.com...
Hello!

How Can I check whether a specific function is used in a workbook?

for eg: SUM is used in any sheets of the Active Workbook?

So that I can have
if used
do this
else
do this

Thanks