It is just an anomaly that occurs from time to time, where there...

  1. 19,112 Posts.
    lightbulb Created with Sketch. 3682
    It is just an anomaly that occurs from time to time, where there is a newly created column with a zero or X at the end of the chart which cant be placed into a new column (yet).
    The VBA keeps looping trying to place it somewhere, but there is no where for it to go.
    So when I hit escape it stops looping and leaves it like this - below - which is correct.

    see the image below, where it can't place the last X

    roam 4.PNG



    cheers
    Last edited by Jako8557: 17/06/20
 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.