| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stubborn date format and range copy
Hi, I would like to recreate this formula (see below) to a whole column but I
am incapable to do so. The problem come from the date format which I cannot change with usual format. They only way I found out was to select the cell, then copy the formula and paste it using the text importation wizard (that I can see when I paste the date). Any other way to go throught this would be accepted. Thanks! Range("M4").Select ActiveCell.FormulaR1C1 = "09/27/2006" Range("W4").Select ActiveSheet.PasteSpecial Format:="Texte Unicode", Link:=False, _ DisplayAsIcon:=False -- Mathieu |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy date in a cell if within a date range | Excel Discussion (Misc queries) | |||
| Find Last cell in Range when range is date format | Excel Discussion (Misc queries) | |||
| copy date based on date -refer to date range | Excel Programming | |||
| Stubborn Date Format | Excel Programming | |||
| Find date and copy range based on that date | Excel Programming | |||
Threaded Mode
