| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a button to copy the values of one range to another
Please give me some help with this I have a range on Sheet1 and a range of the same dimension on Sheet2 . I need code for a button on Sheet1 that when pressed copies the values of the range on Sheet2 into the range on Sheet1 THANK You -- SuitedAces ------------------------------------------------------------------------ SuitedAces's Profile: http://www.excelforum.com/member.php...o&userid=35840 View this thread: http://www.excelforum.com/showthread...hreadid=556302 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use a button to copy the values of one range to another
Hi SuitedAccess,
Try: '============= Public Sub Tester() Dim rng1 As Range Dim rng2 As Range With ThisWorkbook Set rng1 = .Sheets("Sheet1").Range("A1:D10") '<<== CHANGE Set rng2 = .Sheets("Sheet2").Range("C1:F10") '<<== CHANGE End With rng1.Copy Destination:=rng2 End Sub '<<============= --- Regards, Norman "SuitedAces" wrote in message ... Please give me some help with this I have a range on Sheet1 and a range of the same dimension on Sheet2 . I need code for a button on Sheet1 that when pressed copies the values of the range on Sheet2 into the range on Sheet1 THANK You -- SuitedAces ------------------------------------------------------------------------ SuitedAces's Profile: http://www.excelforum.com/member.php...o&userid=35840 View this thread: http://www.excelforum.com/showthread...hreadid=556302 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use a button to copy the values of one range to another
SuitesdAces, something like this,
Sheet1.Range("A1:A20").Value= Sheet2.Range("A1:A20").Value -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "SuitedAces" wrote in message ... Please give me some help with this I have a range on Sheet1 and a range of the same dimension on Sheet2 . I need code for a button on Sheet1 that when pressed copies the values of the range on Sheet2 into the range on Sheet1 THANK You -- SuitedAces ------------------------------------------------------------------------ SuitedAces's Profile: http://www.excelforum.com/member.php...o&userid=35840 View this thread: http://www.excelforum.com/showthread...hreadid=556302 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use a button to copy the values of one range to another
Gentlemen I have tested both methods with success ! Thank you both very much. -- SuitedAces ------------------------------------------------------------------------ SuitedAces's Profile: http://www.excelforum.com/member.php...o&userid=35840 View this thread: http://www.excelforum.com/showthread...hreadid=556302 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy, split and transpose a range of values | Excel Programming | |||
| look up a set of values,copy a range of data into 2nd file | Excel Programming | |||
| Creating a Button to add to existing values while subtracting range | Excel Programming | |||
| copy / paste values for certain range | Excel Programming | |||
| Range COPY function - how to copy VALUES and not formulas | Excel Programming | |||
![SuitedAces[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
