PDA

View Full Version : working with ranges of merged cells



ben_hogan
04-21-2010, 08:08 AM
Dear Experts,
I wonder if you could help me with this little dilemma.
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
Sheets("Notes Tool").Range("B28").PasteSpecial Paste:=xlPasteValues, Transpose:=True
ActiveCell.Offset(, 11).Copy OR
'Sheets("Notes Tool").Range("REASON").PasteSpecial Paste:=xlPasteValues
. . . seem to work.

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?
Thank you very much for your kind help . . .

Marco.-