On Oct 17, 4:51*pm, "kittronald" wrote:
* * On Sheet1,

* * * * A1 = One

* * * * B1 = Two

* * What is the proper code to set ...

* * * * Sheet2.Range("A1:B1")

* * to be equal to Sheet1.Range("A1:B1") , so that on Sheet2

* * * * A1 = One

* * * * B1 = Two

- Ronald K.

simply put in sheet 2

in cell a1 put
=sheet1!a1

in cell b1 put
=sheet1!b1