Return True/False if cell contains formula

Is there a formula or VB code like the =TYPE() function that will return whether a cell contains a FORMULA?

Here's the issue:
I'm writing a macro to update 10,000 sheets. Each sheet has a column that I'm updating with a new formula. Some of these formulas have been previously overwritten with a random number that would delete the formula from the cell. I have to leave the overwritten values where there is no formula, and replace the values of the formulas where they are still intact.

I assume that if I can identify whether there is a formula in the cell or not, I can choose that cell to skip or update. Ideas?

Here is an example formula that would be in a cell (that I would want "identified" as containing a formula):

Please Login or Register  to view this content.

Thanks!

Not quite, but you can build a UDF that will by using:

Please Login or Register  to view this content.

HTH

Cheers,

You can use SpecialCells to identify Cells containing Formulae if that's your intent...

Please Login or Register  to view this content.

The range can be restricted further to a column, row or range of cells, the above simply overrides all Formulas on the active sheet with the text "override"

I'm not entirely sure what it is you're trying to do...

(the same can be applied in terms of xlCellTypeConstants rather than Formulas etc... see: http://msdn.microsoft.com/en-us/libr...ffice.11).aspx)

Thanks for such a fast reply.

I've never used a UDF before and I've never heard of SpecialCells, so I'm going to look into those possibilities.

I will post a reply if I figure out a solution.

Sorry, I guess I coulda 'splain'd that a little better.

How to Create Excel User Defined Functions (UDF)

Open up a new workbook.
Get into VBA (Press Alt+F11)
Insert a new module (Insert > Module)
- Copy and Paste the Excel user defined function "ISFORMULA" -
Get out of VBA (Press Alt+Q)
Use the functions (They will appear in the Paste Function dialog box, Shift+F3, under the "User Defined" category)
If you want to use a UDF in more than one workbook, you can save your functions in your own custom add-in. Simply save your excel file that contains your VBA functions as an add-in file (.xla). Then load the add-in (Tools > Add-Ins...). Warning! Be careful about using custom functions in spreadsheets that you need to share with others. If they don't have your add-in, the functions will not work when they use the spreadsheet.

These instructions are copied from Vertex42 if you need further info.

HTH

Cheers,

Thanks everyone. I ended up using Donkey's SpecialCells idea. It worked very well!

Here is the portion of the code that was used:

Please Login or Register  to view this content.

Thanks Again for the help!