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
|