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!!!