| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coping dates
Hi,
I use this to copy some data from one workbook to another Cells(2, 3).Resize(12, NoMonths).Value = Workbooks (File).Worksheets(SourceSheet).Cells(110, StartColumn).Resize(12, NoMonths).Value when I run it on some machines the dates change from Australian to US. The conversion is in the daynumber, it changes. How do I stop it from changeing the date Thanks MarkS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help with coping rows | Excel Worksheet Functions | |||
| Coping Dates from workbook to workbook | Excel Discussion (Misc queries) | |||
| Coping a formula | Excel Discussion (Misc queries) | |||
| coping | New Users to Excel | |||
| Coping a sheet | Excel Programming | |||
Threaded Mode
