Sheets("Sheet1Name").Range("D4").Copy Destination:= _
Sheets("Sheet2Name").Range("C5")

--

HTH

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

"William DeLeo " wrote in
message ...
Greetings,

I need to use a macro to copy cell values from one sheet to another
without changing the sheet that's in view. I have been using the
following code but my selection method causes the sheet in view to flip
back and forth between the sheet the cells are being copied from to the
one they are being pasted on.

I am using the follwing:

Sheets("Sheet1Name").Select
Range("D4").Select
Selection.Copy

Sheets("Sheet2Name").Select
Range("C5").Select
ActiveSheet.Paste

How can I rewrite this to do all the work in the background? I guess I
need the syntax to copy a range from a sheet without making it
"Active".

Thanks in advance!!


---
Message posted from http://www.ExcelForum.com/