Copy Named Range Below last row of data

[Papi]

What is the best way to copy a named range (A16:T16) callded "Formula_Row" to the row below that last row with data also starting in column A? It should copy the formulas as well.

 

[Fluff]

How about

Sub Copy_NRng()

    Range("Formula_Row").Copy Range("A" & Rows.Count).End(xlUp).Offset(1)

End Sub

 

[Papi]

Thank you Fluff

 

[Papi]

Should this be affected if the range is hidden?

 

[Fluff]

Not that I'm aware of. Is it not working for you?