or this

range("test").rows(2).entirerow.insert

--


Gary Keramidas
Excel 2003


"BeSmart" wrote in message
...
Hi All
I need to select the second row in a named range ("Overviewfinal") and
insert copied rows so that the named range expands to take the new data.

I tried the following, but got an error??
Could someone tell me what I've done wrong & how I should do this?
...
Sheets("Overview Template").Select
Range("Overviewfinal").Range(Cells(1, 1)).EntireRow.Select
Selection.Insert Shift:=xlDown
....
Thank for your help
BeSmart