Variable Not in the cell
 

Hi there,

Can anyone help me.... I have a macro which copies a variable to
cell.

The variable format will always be dd/mm/yyyy

However, this information makes its way to the cell but it doesnt see
to be the value of the cell.... its almost as if it is text sitting o
the cell and not a value. Like for example ="22/09/2008"

Any help much appreciated



--
Message posted from http://www.ExcelForum.com

Variable Not in the cell
 

Dim dt as Date
dt = Cdate("22/09/2008")
ActiveCell.Value = dt
ActiveCell.Numberformat = "dd/mm/yyyy"

--
Regards,
Tom Ogilvy

"rebel1970 " wrote in message
...
Hi there,

Can anyone help me.... I have a macro which copies a variable to a
cell.

The variable format will always be dd/mm/yyyy

However, this information makes its way to the cell but it doesnt seem
to be the value of the cell.... its almost as if it is text sitting on
the cell and not a value. Like for example ="22/09/2008"

Any help much appreciated

R


---
Message posted from http://www.ExcelForum.com/

Variable Not in the cell
 

Thanks To

--
Message posted from http://www.ExcelForum.com