View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris L Chris L is offline
external usenet poster
 
Posts: 1
Default 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