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

Your way will work O.K. between worksheets:


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


If all you want to do is copy within a single worksheet then:


Sub asdf()
Dim r1 As Range
Dim r2 As Range
Set r1 = Columns("Q:Q")
Set r2 = Columns("R:R")
r1.Copy r2
End Sub

--
Gary''s Student


"Metrazal" wrote:


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

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