View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SunTzuComm SunTzuComm is offline
external usenet poster
 
Posts: 30
Default Copying Dates from One sheet to another

Hello, Matt!

You need to format the cells before moving the dates into them.

Range("N1:N4").Select
Selection.NumberFormat = "dd-mmm-yy"
[n1] = Range("First_Date").Value
[n2] = [n1]
[n3] = Range("Date_2").Value
[n4] = [n3]

Regards,
Wes