A
Adam Biddlestone
Recently upgraded to Office XP. When on Excel 2000 this
problem was not apparent, now on Excel 2002:
The source date format is dd/mm/yy and the destination
cell format is dd/mm/yy. However, when using the
following macro to copy fields to destination, the date
has become mm/dd/yy although the cell is still formatted
as dd/mm/yy - so the result is e.g. 01/19/03 rather than
19/01/03 and cannot be corrected unless you manually type
in the correct date.
Dim Irow As Integer
Dim rg1 As Range
Sheets("STORE1").Activate
Set rg1 = Cells(2, 1).CurrentRegion
Irow = rg1.Rows.Count
Range(Cells(Irow + 1, 1), Cells(Irow + 1, 28)).Value =
Range("A2:AB2").Value
Any suggestions are much appreciated.
problem was not apparent, now on Excel 2002:
The source date format is dd/mm/yy and the destination
cell format is dd/mm/yy. However, when using the
following macro to copy fields to destination, the date
has become mm/dd/yy although the cell is still formatted
as dd/mm/yy - so the result is e.g. 01/19/03 rather than
19/01/03 and cannot be corrected unless you manually type
in the correct date.
Dim Irow As Integer
Dim rg1 As Range
Sheets("STORE1").Activate
Set rg1 = Cells(2, 1).CurrentRegion
Irow = rg1.Rows.Count
Range(Cells(Irow + 1, 1), Cells(Irow + 1, 28)).Value =
Range("A2:AB2").Value
Any suggestions are much appreciated.