dear All, I amusing the coding b 1

[robcarr]

dear All,

I amusing the coding below to update an ontime reporting file, and I need to format the date as below, but when dname gets entered into the cell, it foramts as MM/DD/YY HH:MM the cell formatting is dd/mm/yy hh:mm, and makes the ontime reporting incorrect, dname also shows as dd/mm/yy hh:mm, does nayone knwo why this is.

Workbooks.Open Filename:=pathname
mme = Format(Now(), "mmmm&quot
Sheets(mme).Select
Range("d10&quot.End(xlDown).Offset(1, 0).Activate
dname = Format(Now(), "dd/mm/yy hh:mm&quot
ActiveCell.Value = dname


Thanks Thanks Rob.

 

[Simmy]

Hi Rob

I have messed around with this and found that if I use

Dim dname As Date

as the first line of the Subroutine it works for me

Hope this helps

Simmy

 

[robcarr]

that has sorted it.

Thanks



Thanks Rob.