| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| file save error: the file or directory cannot be created | Excel Discussion (Misc queries) | |||
| Save changes in Excel 97 from file created in 2000 | Excel Programming | |||
| Additional file with no extension created during File Save As proc | Excel Discussion (Misc queries) | |||
| Save, Save As, Print Grayed Out when instance created via VBA/VB6 | Excel Programming | |||
| Save, Save As, Print Grayed Out when instance created via VBA/VB6 | Excel Programming | |||
Linear Mode
