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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro will copy formula instead of value 6
Autofill Dynamic Range of Cells 2
macro to copy rows that contain a cell with a certain number 3
Macro that deletes and pastes filterd rows and then some 2
Modify range in VBA 9
Creating Pivot Table with Macro using Multiple Sheets 0
"=TEXT(RC[-1],"MMM")" 4
Need Help with a VBA subroutine 0

Top