Greetings,

I need to use a macro to copy cell values from one sheet to anothe
without changing the sheet that's in view. I have been using th
following code but my selection method causes the sheet in view to fli
back and forth between the sheet the cells are being copied from to th
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
need the syntax to copy a range from a sheet without making i
"Active".

Thanks in advance!

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