Excel 2007 - VB autofill range help

F

Franci

I want to copy the formula down to the last row containing data, which
varies. What am I doing wrong?
Thanks.

Range("K2").Select
LastRow = Range("K2").End(xlUp).Row
ActiveCell.FormulaR1C1 = "=TEXT(RC[-1],""MMMM"")"
Selection.AutoFill Destination:=Range("K2:K" & LastRow)
 
Top