Benjamin_Hogan
New Member
- Joined
- Mar 10, 2010
- Messages
- 16
Dear Experts,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
ffice
ffice" /><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
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
Sheets("Notes Tool").Range("B28").PasteSpecial Paste:=xlPasteValues, Transpose:=True<o
ActiveCell.Offset(, 11).Copy OR<o
'Sheets("Notes Tool").Range("REASON").PasteSpecial Paste:=xlPasteValues<o
. . . seem to work.<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
Thank you very much for your kind help . . . <o
<o
Marco.-<o