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
|