Thread: Whether a Cell contains a Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Whether a Cell contains a Formula
Try this UDF:
Function IsFormula(cellref)
IsFormula = Left(Range(cellref).Formula, 1) = "="
End Function

Regards,
Stefi


€˛Roger€¯ ezt Ć*rta:

What function can be used to determine whether a cell contains a formula?

Thanks in advance for your help.

Roger
Reply With QuoteReply With Quote