Gary,

Is EndRow a different number depending on the sheet? I'm sure that's not
intended, but I wonder if it is.

Doug

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
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