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

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

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

What cells are you trying to select? It's not clear to me.

Barb Reinhardt



"Chris L" wrote:


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