#1
|
|||
|
|||
need to check whether cell contains formula
Is there any formula (or combination thereof) that says whether a cell contains a formula or not?
specifically i want to distinguish a cell with, for example, =A3*C4, from a cell with just a value, say 13.8 |
#2
|
||||
|
||||
Here's a UDF that will do what you ask:
Code:
Function IsFormula(cell) IsFormula = cell.HasFormula End Function |
#3
|
|||
|
|||
Do you want a macro to do this? If so, this is pretty easy.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula in a Cell with condition? | Learner7 | Excel | 1 | 07-19-2010 10:10 AM |
How can I write the following (whole) formula in a single cell? | Learner7 | Excel | 1 | 07-19-2010 10:06 AM |
Protect formula in cell? | markg2 | Excel | 4 | 05-24-2010 11:50 AM |
Moving formula range multiple cells when moving sum over one cell | FraserKitchell | Excel | 4 | 02-26-2010 10:38 AM |
Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |