copy first row of table

[ajm]

to filldown a range on a sheet, the macro recorder proposes:

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?

 

[ajm]

i found an old post from JoeMo that gave me the answer. Thank you @JoeMo

VBA to copy first row in named range to whole named range.

Hello I am looking for VBA to copy the first row in a named range and paste it to whole of the named range. I am sure its very easy but I cant find anything. Thank you tttommy2

www.mrexcel.com

as always, search for knowledge by asking different questions (or, as the case may be, by asking the same question in different ways).

 

[JoeMo]

i found an old post from JoeMo that gave me the answer. Thank you @JoeMo

VBA to copy first row in named range to whole named range.

Hello I am looking for VBA to copy the first row in a named range and paste it to whole of the named range. I am sure its very easy but I cant find anything. Thank you tttommy2

www.mrexcel.com

as always, search for knowledge by asking different questions (or, as the case may be, by asking the same question in different ways).

You are welcome - thanks for the reply.