Identify cells with a value (excluding formulas)

D

Dark_Templar

Hi,

as the forum search is giving me a 404 all the time,I gotta ask:

Is there a function that will tell me if a cell does have a
value,text.
All I can find are fuctions that consider formulas as value too.

Thanks.
 
A

Abode

Sorry if this has been posted multiple times. Put this into a VBA module and
type =FindFormula(A1) into a cell. This will tell you whether or not it is a
formula. Reading back on your post though I think I may have went the wrong
dirrection. If you think something like this would be helpful for you please
let me know and clarify exactly what your looking for.

Function FindFormula(ByVal rng As Range) As Boolean
If Left(rng.Formula, 1) = "=" Then
FindFormula = True
Else
FindFormula = False
End If
End Function
 
E

edcosoft

If you want to know which cells have formulas, use the Edit menu / GoTo
/ Special / formulas. Note the other things you can find with this.

ed
 
E

edcosoft

Or, if you want to know which have values, but not formulas, Edit menu
/ GoTo / Special / check Constants, then check Numbers.

ed
 
D

Dark_Templar

Or, if you want to know which have values, but not formulas, Edit menu
/ GoTo / Special / check Constants, then check Numbers.

ed
Click to expand...

Thats it - but I need it dznamic..as function.
 
Top