Function Used?
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 |
Function Used?
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 |
All times are GMT +1. The time now is 06:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com