View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
IgorM[_2_] IgorM[_2_] is offline
external usenet poster
 
Posts: 41
Default How to check if a certain function is used

Hi

What's the best way to check if a certain spreadsheet function is used in a
cell?
For instance, we want to check if cell A1 uses SUM function considering that
A1 may contain:
1. A1 ="Sum"
2. A1 =SUM(B1:B2)
3. A1 =If(A1="Sum","True",SUM(B1:B2))
These is not a complete list of possibilities. I just wanted to show that
search a formula string for certain words is not the best solution.
Any ideas?

Kind regards
IgorM