Re: $$Excel-Macros$$ *Macro Code Request*

2011-09-20 Thread dguillett1
If you want a macro just use this Sub FillDownSAS() With Range("c2") .Formula = "=a2+b2" .AutoFill Destination:=Range("C2:c" & Cells(Rows.Count, "a").End(xlUp).Row) End With End Sub if you already have the formula in c2 Sub FillDownSAS() range(“c2”).AutoFill Destination:=Range("C2:

Re: $$Excel-Macros$$ *Macro Code Request*

2011-09-20 Thread dguillett1
A very easy way is to put your formula in cell c2 and then DOUBLE click the fill handle (lower right corner) From: Prabhu Sent: Tuesday, September 20, 2011 12:26 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ *Macro Code Request* Hi Friends, Column A & B contains some values

Re: $$Excel-Macros$$ *Macro Code Request*

2011-09-20 Thread NOORAIN ANSARI
Dear Prabhu, Please see attached sheet if it help to u.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Sep 20, 2011 Dat 10:56 PM, Prabhu wrote: