Auto Fill Macro

[ctc005]

I have never written a macro, but I think I can figure it out with a little help.

What I need to do is I have an area set up in my spreadsheet that has calculations (about 130 rows worth) They can all be dragged manually out to the right to fill in how large I need it. They are broked down by month (i.e. my column headers are months) I want a macro to autofill to the right based on how many years I input into G10. So if I entered 10 I want it to copy (i believe a loop is what its called?) the formulas I have in cells J11 through J130 across to the right for 10 years (120 months). Any help is appreciated. Or if I am being too vague let me know.

 

[Norie]

No need for a loop.

With Range("J1:J130")
    .Copy .Offset(, 1).Resize(, Range("G10") * 12)
End With

 

[ctc005]

when I run it, it highlights range and tells me

Compile Error:
Invalid or unqualified reference

 

[Norie]

How exactly did you run it?

 

[ctc005]

copied your code into a new macro and clicked run in the top of my editor screen page

 

[ctc005]

had a typo, found it and corrected it, it works now, thanks sincerely for your assistance.