Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Performance question | Excel Programming | |||
Performance IF(IF or IF(AND | Excel Worksheet Functions | |||
XLL performance in NT and XP | Excel Programming | |||
performance question | Excel Programming | |||
Bad performance | Excel Programming |