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