Range("A1:D20").Copy Destination:=Worksheets("Sheet2").Range("H100")


Is this what you want?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"gav meredith" wrote in message
...
Hi, i have an exisiting code that copies and pastes data within cells
based
upon a numerical value 1. What i am after now is to have a section of a
worksheet (A1 D20) either attach to another worksheet as an appendix or
have the data paste into a section of another worksheet. Problem with the
latter is the formatting of the cells is different so i would assume
inserting the data as an appendix would be a better option.

Any suggestions would be extremely helpful!!!!!

Thank you!!!!