Good Morning!
I am trying to run this to full a calculation down a sheet ( to keep file size small) I am running into errors on the lines indicated below by arrows to the right, any guidance is appreciated!
Sub FillCalc_down()
' FillCalc_down
'
'
Sheets("Item Upload Template").Select
Sheets ("Item Upload Template") <----------
Range("A3:BY3").Select
Application.CutCopyMode = False
*** Selection.AutoFill Destination:=Range("A3:BY12000") <-----------
End Sub
I am trying to run this to full a calculation down a sheet ( to keep file size small) I am running into errors on the lines indicated below by arrows to the right, any guidance is appreciated!
Sub FillCalc_down()
' FillCalc_down
'
'
Sheets("Item Upload Template").Select
Sheets ("Item Upload Template") <----------
Range("A3:BY3").Select
Application.CutCopyMode = False
*** Selection.AutoFill Destination:=Range("A3:BY12000") <-----------
End Sub