Hi all,
I am developing an app with excel using VBA. I want to determine the type of
content of a cell ie, is it text, or numeric, or a formula, or a hyperlink.
How can I possibly do that?
Any methods, events, or functions to obtain this?
Please suggest.

if ActiveCell.Hasformula then


if ActiveCell.Hyperlinks.count 0 then


if vartype(activeCell.Value)

see help on vartype for the values returned.

--
Regards,
Tom Ogilvy


"A.K." wrote in message
...
Hi all,
I am developing an app with excel using VBA. I want to determine the type
of
content of a cell ie, is it text, or numeric, or a formula, or a
hyperlink.
How can I possibly do that?
Any methods, events, or functions to obtain this?
Please suggest.