Code to Copy and Paste

**[email protected]** · 10-09-2008, 09:55 AM

Good morning, Gurus.

I know I've seen the proper way to do this, but couldn't find it in my search. How would I properly code the following to copy and paste values from onw workbook to another?

Please Login or Register  to view this content.

Thanks in advance.

**Kenneth Hobson** · 10-09-2008, 10:12 AM

Please Login or Register  to view this content.

**rwgrietveld** · 10-09-2008, 10:48 AM

You can do without switching from WB1 to WB2

Please Login or Register  to view this content.

**royUK** · 10-09-2008, 11:03 AM

Try this

Please Login or Register  to view this content.

**[email protected]** · 10-09-2008, 01:31 PM

Ken - yours looked a lot neater, and avoided jumping between sheets.
RW - your avoided jumping, but was longer than the original, and difficult to follow.
Roy - As usual, comes to the rescue!

One last question. If I just wanted to copy the values over, would it be as simple as shown below? (It's never as simple as it should be.)

Please Login or Register  to view this content.

**Kenneth Hobson** · 10-09-2008, 01:41 PM

Value is the default property of Range.

While we could do Range("A1")=2, we should be more explicit and do: Range("A1").Value=2.

**royUK** · 10-09-2008, 01:47 PM

I was swapping backwards & forwards to check which cells you were copying & didn't notice I hadn't added the .Value. As Ken says I would usually always do so.