Re: $$Excel-Macros$$ fill a column with a formula to a specific index.

Thanks a lot! It worked out. On Tue, Feb 25, 2014 at 3:02 PM, mrExcel4u wrote: > Sub test11() > > With Sheets("testing") >.Range("F1:F" & .Cells(Rows.Count, "A").End(xlUp).Row) = "=SUM(E1,D1)" > End With > > End Sub > > Thanks & regards, > > www.MrExcel4U.com

Re: $$Excel-Macros$$ fill a column with a formula to a specific index.

Sub test11() With Sheets("testing") .Range("F1:F" & .Cells(Rows.Count, "A").End(xlUp).Row) = "=SUM(E1,D1)" End With End Sub Thanks & regards, www.MrExcel4U.com On Tue, Feb 25, 2014 at 2:54 PM, MH wrote: > > Hello, > > The following code fills the

Re: $$Excel-Macros$$ fill a column with a formula to a specific index.

Dear Maria, Pl share the workbook with us. Warm Regards, Gawli Anil. On Tue, Feb 25, 2014 at 2:54 PM, MH wrote: > > Hello, > > The following code fills the column till the last row in excel, i dont want > to do this. > I want the formula till lets say column A's last filled index (e.g. till 6

$$Excel-Macros$$ fill a column with a formula to a specific index.

Hello, The following code fills the column till the last row in excel, i dont want to do this. I want the formula till lets say column A's last filled index (e.g. till 6th row if column A has 6 values). Sub test11() With Sheets("Sheet1") * .Range(.Range("F:F"), .Range("F" & .Rows.Count).