Is there a formula that will check a cell to determine if it is a constant (123) vs a formula (=a1)?
G Guest Jun 28, 2004 #1 Is there a formula that will check a cell to determine if it is a constant (123) vs a formula (=a1)?
P Peo Sjoblom Jun 28, 2004 #2 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) Jonathan Cooper said: Is there a formula that will check a cell to determine if it is a constant Click to expand... (123) vs a formula (=a1)?
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) Jonathan Cooper said: Is there a formula that will check a cell to determine if it is a constant Click to expand... (123) vs a formula (=a1)?
G Gord Dibben Jun 28, 2004 #3 Jonathan User Defined Function Function IsFormula(cell) Application.Volatile IsFormula = cell.HasFormula End Function Gord Dibben Excel MVP
Jonathan User Defined Function Function IsFormula(cell) Application.Volatile IsFormula = cell.HasFormula End Function Gord Dibben Excel MVP
F foolio Jun 29, 2004 #4 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
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
D Dave Peterson Jun 29, 2004 #5 Since you're passing the cell, I think you could drop the application.volatile line.
G Gord Dibben Jun 29, 2004 #6 Thanks Dave. Gord Since you're passing the cell, I think you could drop the application.volatile line. Click to expand...
Thanks Dave. Gord Since you're passing the cell, I think you could drop the application.volatile line. Click to expand...