Loop until won't stop!?

Tried this but it still goes past the loop and creates a new sheet which it can't name.

what does the end(x1up) do?

the value of x1up when it finishes is -4162 but i only have 2 row in this test example? should it not be 65536 less 2?

i have tried clearing the cells below my data but it didnt help?

thanks

The instruction

Please Login or Register  to view this content.

do the same thing than go to max row of column 2 (for example B65536) then press 'End' and 'Up' to go to the last row of column 2.

To fix your problem try to do so:

Please Login or Register  to view this content.

Regards,
Antonio

thanks for the help.

i sorted it buy just using

n=1

my coded

n=n+1
end sub

thanks for all the help its mcuh appreciated

any thoughts on the deleting sheets questions? (see post)