Excel Cell type determination in VBA 1

[popper]

Hi there,

Does anyone know a way of telling in VBA code what type of data a given spreadsheet cell holds where the type would be either

numeric (like 36)
text (like "Saturday")
or
formula (like "=A1*2")

Would there by a property of the cell which would reveal this or do we have to write code to examine each character of the cell contents until we could establish this?

Any help would be appreciated.

Thank you

 

[TonyJollans]

Depending on exactly what you may have, take a look at the HasFormula property of the Cell before perhaps checking TypeName(CellRef.Value) for "String" or "Double" or "Boolean" (or "Empty" if you don't check for that separately)

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

Professional Office Developers Association