VBA Script to Sort a row in ascending order, then go to next row and repeat

I have thousands of rows of 5 numbers in columns B-F that I need to sort horizontally in ascending order. I am trying to use VBA for this because I want each individual line to be in order.

For an example.

22 5 38 99 01 will need to be 01 05 22 38 99

and so on for the next row under neath it. I tried recording a code but it keeps the rows in my recording. I'd like it to go to the next row "X" and sort for columns B-F and then repeat about 2000 times.

Any suggestions on how to rewrite this?

Thanks in advance.

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

These work, thank you guys!