![]() |
#1
|
|||
|
|||
![]() 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 | Thread Starter | Forum | Replies | Last Post |
![]() |
Learner7 | Excel | 1 | 07-19-2010 10:10 AM |
![]() |
Learner7 | Excel | 1 | 07-19-2010 10:06 AM |
![]() |
markg2 | Excel | 4 | 05-24-2010 11:50 AM |
![]() |
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 |