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