| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changeing date formats when not intended
Hi,
I use this piece of code to copy data from one place to another Range("B" & 11 + (iRowCounter * iCount) & ":D" & 10 + (iRowCounter * (iCount + 1))).Value = Worksheets("extract").Range("A16:C" & 15 + iRowCounter).Value one of the values is a date which is in the dd/mm/yyyy format in the source but at the destination it is mm/dd/yyyy even when it says it is not. How do I stop this from happening MarkS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Not Working As Intended | Excel Worksheet Functions | |||
| Limit Macro to Intended worksheet. | Excel Worksheet Functions | |||
| macro not working as intended | Excel Programming | |||
| Code deleting values -- not as intended | Excel Programming | |||
| Changeing a graph | Excel Programming | |||
Threaded Mode
