AutoFill Macro from ActiveCell Fail

Hi All,

My name is Edward and I'm newbie to these forums. I would really appreciate if someone is able to help me as I have read every forum on this issue and tried every solution I can see but I'm still getting a Run-time error '1004' .

I'm trying to create an autofill macro from an Active Cell in Column G that then fills down Column G and stops at the row where data exists in Column C. For example say the active cell is "G10" and I have text up to cell "C20", I would thus like the macro to autofill over the range G10:G20.

My current autofill code is:

Selection.AutoFill Destination:=Range(ActiveCell & Range("C" & lastRow))


I'm not sure if this makes any difference but the data in Column C is text based and not numerical.

Thank you so much Holger that worked perfectly!

You have seriously just made my day!!