Identify cells with a value (excluding formulas)
 

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

Identify cells with a value (excluding formulas)
 

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

Identify cells with a value (excluding formulas)
 

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

Identify cells with a value (excluding formulas)
 

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

ed

Identify cells with a value (excluding formulas)
 

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

Identify cells with a value (excluding formulas)
 

Pardon me. What is "dznamic" ? ed