Data Type Inquiry

[RaunLGoode]

Is there a way to determine the data type of the contents of a cell and then use the data type as a condition for an "If" statement ?
If so, could someone point me in the right direction?

Kind of like :
If ActiveCell.Type is Integer Then
....
End If
I know the "ActiveCell" object doesn't support the "Type" property, That seemed to be the easiest way to illustrate my point.... and I am not sure how else to interrogate a cell.

Can you assign the data type to a variable or get the data type to display in a message Box?

 

[shades]

Howdy.

In VBA use TypeName to determine data type.
________
MEXICOCITY HOTEL

 

[RaunLGoode]

Thank you for the help

 

[RaunLGoode]

Data Type Inquiry-revisited

Once I have determined what data type a cell value is,

How can I re-define the data type of the cell value?