try
Sub copynamedrowandinsert()
ActiveCell.EntireRow.Insert
Range("myrow").Copy Cells(ActiveCell.Row, 1)
End Sub

--
Don Guillett
SalesAid Software

"Mikey2005" wrote
in message ...

Afternoon all,

How is it possible to get VBA to select a user defined row (Defined in
Insert - Name - Define) Copy the row and insert the copied cells
below.... Its for a huge report I'm working on...

It's prooving to be quite a dilemer and i cant crack it, if you need an
example or any further data then happy to provide... Please HELP!


Thanks in advance

Mike


--
Mikey2005
------------------------------------------------------------------------
Mikey2005's Profile:
http://www.excelforum.com/member.php...o&userid=31316
View this thread: http://www.excelforum.com/showthread...hreadid=510015