You might also want to compare
Sheet1.Cells(1, 1)
with
Sheet1.Range("A1")
Also, if you are looping through a range, the above in a loop will be far
slower than doing the entire range in one go, e.g.,
Sheet1.Range("A1:Z25").Value = Sheet2.Range("A1:Z25").Value
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"Barb Reinhardt" wrote in message
...
Sheet1.Cells(1,1) = Sheet2.Cells(1,1)
Sheet1.Cells(1,1).value = Sheet2.Cells(1,1).value
Or something else?
Thanks,
Barb Reinhardt