JZB
04-27-2009, 01:44 AM
Hi Guys
I am currently writing very simple formula loops but the data is very large so can take up a lot of time and memory.
Is there a way i can incorporate the lastrow variable into the autofill function? this is what i am writing but it is not happy :banghead:
Range("K2").Select
ActiveCell.FormulaR1C1 = "=ABS(RC[-3])"
Range("K2").Select
nlastrow = Range("A65536").End(xlUp).Row
Selection.AutoFill Destination:=Range("K" & nlastrow)
Cheers
Jon
I am currently writing very simple formula loops but the data is very large so can take up a lot of time and memory.
Is there a way i can incorporate the lastrow variable into the autofill function? this is what i am writing but it is not happy :banghead:
Range("K2").Select
ActiveCell.FormulaR1C1 = "=ABS(RC[-3])"
Range("K2").Select
nlastrow = Range("A65536").End(xlUp).Row
Selection.AutoFill Destination:=Range("K" & nlastrow)
Cheers
Jon