I have a formula at a location on a worksheet.
When I select that cell, I want to copy that formula across the worksheet for 7 columns, but Autofill is copying the value rather than the formula.
Any ideas how to stop this and copy only the formula.
This is the code that I'm using.
Range("AU65536").End(xlUp).Offset(2, 0).Select Selection.AutoFill Destination:=Range(ActiveCell, ActiveCell.Offset(0, 7)), Type:=xlFillDefault