Below is the information out of the help for the GET.CELL() function but I'm looking for the equivalent test in VBA for the type_num = 4 situation. I see that #4 below is "4 Same as TYPE(reference)." But what does this mean? VBA has test for DataType, but thats good for PivotTables. I want to test a cell when it has general formatting to know if the data in the cell is a "date", or number, or string, or whatever. What are all of the datatypes that a cell can have when formatted in the General Format?

Any thoughts?

================
Here's the first part out of the help. The same help file has NOTHING in it for TYPE(reference). ugh!
================

Macro Sheets Only
Returns information about the formatting, location, or contents of a cell.
Use GET.CELL in a macro whose behaviour is determined by the status of a
particular cell.

Syntax

GET.CELL(type_num, reference)
Type_num is a number that specifies what type of cell information you
want. The following list shows the possible values of type_num and the
corresponding results.

Type_num Returns

1 Absolute reference of the upper-left cell in reference, as text in the
current workspace reference style.
2 Row number of the top cell in reference.
3 Column number of the leftmost cell in reference.
4 Same as TYPE(reference).
5 Contents of reference.
6 Formula in reference, as text, in either A1 or R1C1 style depending on the
workspace setting.
7 Number format of the cell, as text (for example, "m/d/yy" or "General").
8 Number indicating the cell's horizontal alignment:
1 = General
2 = Left
3 = Center
4 = Right
5 = Fill
6 = Justify
7 = Center across cells