spill
 

I want to store the contents of a cell in a variable. the content is in the
form of a date (e.g. 2006-12-31). I do not know how to save this since
Integer does not accept that data type and i am not familiar with the other
data types. please please help!!!

spill
 

dim dt as Date
dt = ActiveCell.Value

--
Regards,
Tom Ogilvy



"april27" wrote:

I want to store the contents of a cell in a variable. the content is in the
form of a date (e.g. 2006-12-31). I do not know how to save this since
Integer does not accept that data type and i am not familiar with the other
data types. please please help!!!