You can use the Excel macro function GET.CELL.

See this:

http://groups.google.com/group/micro...cf859ecd?tvc=2

--
Biff
Microsoft Excel MVP


"Joe User" <joeu2004 wrote in message
...
"T. Valko" wrote:
i need a function so i can use it in a formula setting.

You can do this without VBA code but it depends on how you
intend to use it/do it.

Biff, regardless of RK's answer, could you explain what you have in mind,
for my edification.


----- original message -----

"T. Valko" wrote in message
...
thanks but i need a function so i can use it in a formula setting.

You can do this without VBA code but it depends on how you intend to use
it/do it.

Do you want to identify cells that contain formulas and highlight them
with conditional formatting? Or, some other use?

Need more details.

--
Biff
Microsoft Excel MVP


"rk0909" wrote in message
...
thanks but i need a function so i can use it in a formula setting.
regards,
RK

"FSt1" wrote:

hi
you might consider the goto function.
press F5. click the special button bottom right.
check formula then ok. excel will high light all formulas.
you can do the same with constrants.

regards
FSt1

"rk0909" wrote:

Is there a way using excel funtions (not UDF) to find if a cell
contains a
formula vs. a number (constant).
I looked around the forum but did not find anything. I tried using
cell
function and left function but they return the value in the formula
itself.
Any help is appreciated.
Regards,
RK