File, Save changes all dates in column to 1/0/00, created with VBA

  • Thread starter Thread starter Chris L
  • Start date Start date
C

Chris L

I copy data and format from to a sheet it has regular dates such as
12/4/67. It has format category Date with type 3/14/01. It looks
great. I can copy it etc.

But, when I save the spreadsheet from the menu bar, all of the values
in one of the date columns changes to 1/0/00.

The code I use is:

Sheets(FROM).Select
Range(Cells(ROW1), Cells(ROW2, 32)).Select
Selection.Copy
Worksheets(TO).Activate
Worksheets(TO).Cells(ROW87, 88).Select
ActiveSheet.Paste

What do I do to fix it?

Thank you,
Christopher Lusardi
 
Back
Top