Copy/Paste into a Range

[Benjamin_Hogan]

Dear Experts,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I wonder if you could help me with this little dilemma.<o></o>
From the previous question I posted I just realized I need to add another piece of information to be Copy/Pasted from NOTE JOURNAL 3 Worksheet into Note Tool Whorksheet. MD gave the code for a single cell and it works fine, but in this case I have the Range B28:V30 which I have also tried as “REASON” and neither<o></o>
Sheets("Notes Tool").Range("B28").PasteSpecial Paste:=xlPasteValues, Transpose:=True<o></o>
ActiveCell.Offset(, 11).Copy OR<o></o>
'Sheets("Notes Tool").Range("REASON").PasteSpecial Paste:=xlPasteValues<o></o>
. . . seem to work.<o></o>
<o> </o>
All I want is to be able to paste the content of a cell in a Woorksheet into a Range of another Worksheet. What shall I do?<o></o>
Thank you very much for your kind help . . . <o></o>
<o> </o>
Marco.-<o></o>

 

[Gerald Higgins]

It would probably help if you continue in the original thread, or at least post a link to it, so that anyone reading this gets a chance to find out what has been said earlier.

 

[Benjamin_Hogan]

You are totally right Gerald,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I’ll make a reference to the original thread: http://www.mrexcel.com/forum/showthread.php?p=2274769#post2274769 which by the way I haven’t heard about.<o></o>
I was noticing the way you solved my problem: not only you are good at Excel, you are also a philosopher. I showed it to a college of mine and he had no clue. That’s the problem with this world.<o></o>
Thank you very much for your help and talk to you soon . . .<o></o>
Marco.-<o></o>