Hi Ozzie

Do you want to copy the cells from ws1 to the sheets?


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Ozzie via OfficeKB.com" <u18021@uwe wrote in message news:5bdc2249a6372@uwe...
Morning Ron

Cheers for the code, inserting the additional lines and deleting the columns
works fines however the the pasting of the copied cells doesn't seem to work?
any ideas.

Cheers for your help,

David


Ron de Bruin wrote:
Oops

To insert the rows use

WSNew.Range("A1:A4").EntireRow.Insert

Hi

[quoted text clipped - 38 lines]

David

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200602/1