Function to return data type?

[chandler]

Is there a function that can return the data type of an array? Somewhere along the lines, the data types my array is reading in from the spreadsheet may be getting converted from numeric values and dates to something else. Thanks.



Chandler
I ran over my dogma with karma!

 

[PHV]

Have a look at the TypeName and VarType functions.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886