Formula vs Constant

[Guest]

Is there a formula that will check a cell to determine if it is a constant (123) vs a formula (=a1)?

 

[Peo Sjoblom]

Only if you use a UDF

http://www.mvps.org/dmcritchie/excel/formula.htm#HasFormula

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

Is there a formula that will check a cell to determine if it is a constant

(123) vs a formula (=a1)?

 

[Gord Dibben]

Jonathan

User Defined Function

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

Gord Dibben Excel MVP

 

[foolio]

May or may not be useful for what you are trying to do.... but you coul
always hit Ctrl ~ to manually see what is a constant and what is
formula.

Or you could copy the row to another row. Do a replace on just that ro
and replace "=" with "FORMULA IS " or something along those lines

 

[Dave Peterson]

Since you're passing the cell, I think you could drop the application.volatile
line.

 

[Gord Dibben]

Thanks Dave.

Gord

Since you're passing the cell, I think you could drop the application.volatile
line.