Use the Vartype function from VBA

See Excel VBA help for details.

--
Regards,
Tom Ogilvy


"Jim Watkins" wrote:

I'm looking for a way to test, in an Excel VBA subroutine, whether a specific
cell value is (1) a numeric value that has been formated as date, (2) a
numeric value that has been formated as time, or (3) a "reggular" numeric
value.