Excel 2010 function to test if a cell has a formula or is input (number or text)

[jerry12302]

I use Excel 2010, I have been searching for a solution to determine whether a cell contains a formula of any kind, or is just hard input (value or text.)

Isformula is not included in Excel 2010, nor is any use of Hasformula.

I tried suggested UDF solutions, such as

Function IsFormula(cell_ref As Range)
IsFormula = cell_ref.HasFormula
End Function

None have worked, I get a #NAME? Error every time, and my workbook is saved as an xlsm, macro enabled. I placed the Function in a module, under General.

Has anyone found a solution that works in Excel 2010???

 

[RoryA]

I get a #REF! error now

Unless you deleted the cell it was referring to, that shouldn't be possible. If other UDFs are also giving #NAME? errors, it suggests that macros are disabled for that workbook.

 

[jolivanes]

What is cell_ref?

 

[jerry12302]

Unless you deleted the cell it was referring to, that shouldn't be possible. If other UDFs are also giving #NAME? errors, it suggests that macros are disabled for that workbook.

I didn't delete the cell it was referring to. I deleted the formula and typed it again to be sure, referring to the cell J3, which has a value of 1 in it. I also tried it referring to cell J4, which has a formula, =J3+1

I keep getting #REF! errors.

Unless you deleted the cell it was referring to, that shouldn't be possible. If other UDFs are also giving #NAME? errors, it suggests that macros are disabled for that workbook.

Update, I checked named ranges. I don't remember naming any ranges, but there was a range name isformula. I deleted the range name, and now the function IsFormula works.

Weird.

Thank you for your help.