Code to test for cells not containing formulas

[Jonsson]

Hi,

I have a large workbook, containing a lot of formulas in several sheets.

I need a code to test if the cells are empty from formulas.

Something like:

Test marked cells in these sheets, and IF cell does not contain formula = red

Any ideas, anyone?

Any kind of help is apprecciated!

//Thomas

[mangesh_yadav]

IsNumeric(Range("A1").Formula) evaluates to true if it contains a plain number, and if it contains a formula, it evaluates to false.

- Mangesh

[Jonsson]

Thanks,

//Thomas