Hello All:

I have a spreadsheet with two columns both containing serial date/time.
Column A is formatted using a valid date format and column B is formatted
using a valid time format.

If I use the following:

SourceArray = Range.Value
Assuming that Range is a selection of two columns and at least one row.

TypeName(SourceArray(1,1))
returns Date
TypeName(SourceArray(1,2))
returns Double

Does Excel not evaluate a column formatted as time to be a valid portion of
a date and therefore type the value as a Date?

Any insight would be greatly appreciated.

Mike.