VBA - Formula AutoFill

[ChrisFoster]

Hi all,

I am trying to get VBA to autofill a formula to the last active cell in the row. I have the below code, which works fine in other macros I've got running but not in this one I'm now working on.
It just debugs.

ActiveCell.AutoFill Range(ActiveCell, ActiveCell.Offset(0, -1).End(xlDown).Offset(0, 1))

Can anyone help please?

Regards,

Chris

 

[Fluff]

What is the activecell when you run the code & what errors do you get?