Drag formula without removing formatting

[Wamhoi]

Hi All,

I want to drag a formula without removing the highlighting and other formatting already existing. What would I have to change in the following vba snip

Range("AC2:AI2").AutoFill Destination:=Range("AC2:AI2").Resize(lastline), Type:=xlFillDefault

Thanks!

 

[Jonmo1]

Perhaps

Range("AC2:AI2").Formula = Range("AC2").Formula