Cell contents in Excel??

  • Thread starter Thread starter A.K.
  • Start date Start date
A

A.K.

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.
 
Back
Top