performance question
 

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

performance question
 

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

performance question
 

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

performance question
 

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

performance question
 

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

performance question
 

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