Excel AUTOFILL WITH VBA

Excel AUTOFILL WITH VBA AUTOFILL WITH VBA open a new file and insert button save as macro enabled excel file assign macro to the button and paste below code Sub Button1_Click() Dim range1 As Range Dim range2 As Range Set range1 = Sheet1.Range("A1:A2") Set range2 = Sheet1.Range("A1:A10") range1.AutoFill Destination:=range2 End Sub