I think Default Fill option will take minimum time then User Define Macro.
You can fill Down your Formula By Ctrl+D
On Tue, Jul 5, 2011 at 2:58 PM, Rash wrote:
> Hi All,
>
>
> I have excel file with 12000+ rows, and 10 column where i have used Vlookup
> and sumif function in the second row, i ne
Hi Dear,
You can do this with the help of record macro easily.
Please forward me your sheet i will try to help you.
Thanks & regards,
Vikas verma
On Tue, Jul 5, 2011 at 2:58 PM, Rash wrote:
> Hi All,
>
>
> I have excel file with 12000+ rows, and 10 column where i have used Vlookup
> and sumif
Sub Test()
Dim Rng As Range
Lrow = ActiveSheet.Range("A65536").End(xlUp).Row ' Last Row in Column A.
Set Rng = ActiveSheet.Range("B1") ' Cell where you have the vlookup formula
Rng.AutoFill Destination:=Range("B1" & ":B" & Trim(Str(Lrow))),
Type:=xlFillDefault
End Sub
On Tue, Jul 5, 2011 at 2:58
