Thread: A function to indicate whether a cell contains formula or value?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben
 
Posts: n/a
Default A function to indicate whether a cell contains formula or value?
With a User Defined Function such as

Function IsFormula(cell)
Application.Volatile
IsFormula = cell.HasFormula
End Function


Gord Dibben MS Excel MVP

On Wed, 7 Jun 2006 13:18:02 -0700, Dave T <Dave
wrote:

Is there a function to return logical indication of whether a cell contains
formula or value? Need it for conditional cell formating.

Reply With QuoteReply With Quote