doesn't matter. my code runs fine i was just curious.

--


Gary


"Doug Glancy" wrote in message
...
Gary,

What I meant was, does the value for endRow change depending on which sheet is
active? That might explain the difference in time. I'm not sure what you
meant in your reply.

Maybe you should post more code.

Doug

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
no, it's on the same sheet, but it keeps changing.

--


Gary


"Doug Glancy" wrote in message
...
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