Thank you Paul,
that looks so much better for me and so much more attractive on the eyes than trying to find the XX in my long code.
I put a bunch of placeholders in order in the Column - then i tried to number them and it numbered the wrong column
Then i had to copy and paste them all over again - set them up in the columns, so that was half my morning.
ok i can put all my columns on the top and this will sort them out nicely and number them now in order
so i dont have to accidently put the wrong xx in the wrong place in the wrong column
well excel keeps jumping horizontally so i blame excel for that one![]()
Cheers for the great code Paul
thanks to Jan for the loop
and good thursday to all