i forgot to add one other thing.

this is without application.screenupdating = false at the beginning of the code.
with it in there, they are about the same.

wondering why it makes such a difference depending on which sheet is active. i
would have though that it would be faster if the sheet i was copying to, ws2,
was active.

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i am using a for loop to copy some data, well not actually copy.
this is one example:
ws2.Range("G" & z) = ws.Range("C" & endRow)

if ws2 is the active sheet, it runs very fast. if ws is active, it is a lot
slower.

just wondering why?

--


Gary