If I understand your question, the answer should be:
Worksheets ("Master").Range ("Q:Q").Copy Worksheets("Sjournal").Range("R:R")

I have doubts: it looks too trivial

HIH
--
AP


"Metrazal" a écrit
dans le message de
...

Code:

Worksheets ("Master").Range ("Q:R").Copy Worksheets("Sjournal").Range
("U:V")


What's the best code to copy just "Q" to "R"


Thanks,

Met


--
Metrazal
------------------------------------------------------------------------
Metrazal's Profile:
http://www.excelforum.com/member.php...o&userid=31648
View this thread: http://www.excelforum.com/showthread...hreadid=515849