| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
| copy range and paste into every 3rd cell of new range | New Users to Excel | |||
| Macro to copy a specified range to a variable range | Excel Programming | |||
| Create/copy combo boxes in one range if condition is met in a different range | Excel Programming | |||
| Copy From A Range To A Range | Excel Programming | |||
![Brian Matlack[_26_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
