simora
03-30-2022, 02:34 AM
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
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