Posts by TripleBBB

    I have written a script to go through and copy cells, paste them in multiple locations, then repeat the loop which is determined by the row count. The second time it goes through the loop it is supposed to select the same range as the first loop and then offset by an integer of 1 for each loop but it consistently copies the wrong cell on the 2nd loop and beyond.


    Where it says

    Code
     Range("B2:K2").Offset(x, 0).Copy

    It works perfectly the 1st time and then the 2nd time and beyond it ends up Copying cell P1 for some reason.


    I'm beyond frustrated...please help!