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.


--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=541235

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


"Dark_Templar" wrote:


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.


--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=541235

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

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

ed

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

ed

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


--
Dark_Templar
------------------------------------------------------------------------
Dark_Templar's Profile: http://www.excelforum.com/member.php...o&userid=33279
View this thread: http://www.excelforum.com/showthread...hreadid=541235

Pardon me. What is "dznamic" ? ed