to filldown a range on a sheet, the macro recorder proposes:
where row 6 on the sheet is the first row of data in the named range "CalcPPR"
what is the syntax for doing the same thing with a Table?
Code:
Range("A6:X6").Select
Selection.AutoFill Destination:=Range("CalcPPR"), Type:=xlFillDefault
where row 6 on the sheet is the first row of data in the named range "CalcPPR"
what is the syntax for doing the same thing with a Table?