Copy range to range
 

Hello!

Cells(1, "g").Value = Cells(1, "a").Value
This code copies the data in column A to column G as values only.

How can I make it work for a full range?

I tried this but it does not work.
Range("range1").Value = Range("range2").Value

Please help a novice! Thanks!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=484887

Copy range to range
 

shouldn't be a problem as long as they are the SAME size.

Sub copyrangevalues()
Range("g9:i9").Value = Range("d9:f9").Value
End Sub

--
Don Guillett
SalesAid Software

"Brian Matlack"
wrote in message
news:Brian.Matlack.1yhviz_1131984944.9024@excelfor um-nospam.com...

Hello!

Cells(1, "g").Value = Cells(1, "a").Value
This code copies the data in column A to column G as values only.

How can I make it work for a full range?

I tried this but it does not work.
Range("range1").Value = Range("range2").Value

Please help a novice! Thanks!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile:
http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=484887

Copy range to range
 

Brian,

Range("range1").Copy Destination:=Range("range2")

OR

Range("Range1").Copy Range("range2")

HTH

"Brian Matlack" wrote:


Hello!

Cells(1, "g").Value = Cells(1, "a").Value
This code copies the data in column A to column G as values only.

How can I make it work for a full range?

I tried this but it does not work.
Range("range1").Value = Range("range2").Value

Please help a novice! Thanks!!


--
Brian Matlack
------------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...fo&userid=3508
View this thread: http://www.excelforum.com/showthread...hreadid=484887

Copy range to range
 

Thanks Don!
I did try that. It appears I misspelled my range name cause now i
works fine! Thank

--
Brian Matlac
-----------------------------------------------------------------------
Brian Matlack's Profile: http://www.excelforum.com/member.php...nfo&userid=350
View this thread: http://www.excelforum.com/showthread.php?threadid=48488