| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
Hi,
Please tell me what is wrong with the below statements. I'm positive that it is a trivial error but I cant seem to figure this out. This code works fine if I use absolute cells references i.e "D1  7" ratherthan pasteMonthStart, & pasteMonthEnd. ActiveCell.Offset(0, 3).Select ActiveCell.FormulaR1C1 = "=TEXT(RC[-3],""mmmmmmmmm_yyyy"")" Range(pasteStart).Select Selection.AutoFill Destination:=Range("pasteMonthStart, & pasteMonthEnd") Thank you kindly Deecrypt |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Try:
Selection.AutoFill Destination:=Range(pasteMonthStart, pasteMonthEnd) Mike F "Deecrypt" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > Hi, > Please tell me what is wrong with the below statements. I'm positive > that it is a trivial error but I cant seem to figure this out. This > code works fine if I use absolute cells references i.e "D1 7" rather> than pasteMonthStart, & pasteMonthEnd. > > ActiveCell.Offset(0, 3).Select > ActiveCell.FormulaR1C1 = "=TEXT(RC[-3],""mmmmmmmmm_yyyy"")" > Range(pasteStart).Select > Selection.AutoFill Destination:=Range("pasteMonthStart, & > pasteMonthEnd") > > > Thank you kindly > Deecrypt > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
Thanx for your prompt reply Mike,
I tried your solution but was unsuccessful. Eventually found the below solution so am displaying that for the benefit of all. Range(pasteMonthStart).Select Selection.AutoFill Destination:=Range(pasteMonthStart & ":" & pasteMonthEnd) Thank you Deecrypt Mike Fogleman wrote: > Try: > > Selection.AutoFill Destination:=Range(pasteMonthStart, pasteMonthEnd) > > Mike F > > "Deecrypt" <(E-Mail Removed)> wrote in message > news:(E-Mail Removed)... > > Hi, > > Please tell me what is wrong with the below statements. I'm positive > > that it is a trivial error but I cant seem to figure this out. This > > code works fine if I use absolute cells references i.e "D1 7" rather> > than pasteMonthStart, & pasteMonthEnd. > > > > ActiveCell.Offset(0, 3).Select > > ActiveCell.FormulaR1C1 = "=TEXT(RC[-3],""mmmmmmmmm_yyyy"")" > > Range(pasteStart).Select > > Selection.AutoFill Destination:=Range("pasteMonthStart, & > > pasteMonthEnd") > > > > > > Thank you kindly > > Deecrypt > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| What has priority: PATH from User variables or system variables? | Sabine Elsner | Windows XP Help | 3 | 21st Oct 2008 02:42 PM |
| Outlook AutoFill Delete one autofill entry only | katr52@yahoo.com | Microsoft Outlook Discussion | 4 | 5th Oct 2006 10:37 PM |
| autofill with variables trouble | akh2103@gmail.com | Microsoft Excel Programming | 1 | 21st Jul 2006 10:46 PM |
| Autofill: Need to autofill one week block, (5) weekday only into cells. | dstock | Microsoft Excel Misc | 1 | 17th Jun 2005 08:21 PM |
| Q. Autofill question: Can I autofill alpha characters like I can numbers? | George | Microsoft Excel Programming | 5 | 7th Aug 2004 10:33 AM |
