VBA For Next Loop Selecting Wrong Cell after first loop

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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!

  • I need to grab any entries in Columns F - J on "Worksheet" and then I need to move them into a single column while also grabbing the TimeStamp in Column B.


    In the example data I provided, this list would look like this.

    ColumnA Column B

    B11 F11

    B39 F39

    B39 G39


    And so on.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!