Thread: Coping dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Scholes Mark Scholes is offline
external usenet poster
 
Posts: 16
Default Coping dates

Hi,
I use this to copy some data from one workbook to another

Cells(2, 3).Resize(12, NoMonths).Value = Workbooks
(File).Worksheets(SourceSheet).Cells(110,
StartColumn).Resize(12, NoMonths).Value

when I run it on some machines the dates change from
Australian to US. The conversion is in the daynumber, it
changes.
How do I stop it from changeing the date

Thanks MarkS