Hi, I need to check if a cell has a formula or a simple number in it. Any ideas? scooper
S scooper Oct 23, 2006 #1 Hi, I need to check if a cell has a formula or a simple number in it. Any ideas? scooper
D Dave F Oct 23, 2006 #2 Select the cell and see what appears in the formula bar. Alternatively, select the entire worksheet, go to Edit--Go to--Special--Objects and see if the cell is highlighted. Finally, you could create a UDF, getformula, which would allow you to check any cell for its formula: http://www.mvps.org/dmcritchie/excel/formula.htm
Select the cell and see what appears in the formula bar. Alternatively, select the entire worksheet, go to Edit--Go to--Special--Objects and see if the cell is highlighted. Finally, you could create a UDF, getformula, which would allow you to check any cell for its formula: http://www.mvps.org/dmcritchie/excel/formula.htm
