Benjamin_Hogan
New Member
- Joined
- Mar 10, 2010
- Messages
- 16
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>
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>