Search range macro change

Hi

I have a macro, below, that works just fine but I was wondering if it’s possible to add one additional condition to it. If someone could just look to see if this is possible I would be very grateful.

- The code searches the ranges C21:C35,P38:P52,Z40:Z60,AE40:AE75 (sample data ranges) for any sets of numbers such as 1-11, 15- 5, 20-5 etc.
- The code then moves the found set of numbers down one cell. As an example if there is a 1-1 in cell C21 the code would move it to cell C22 and the last number in the set would be increased by one to 1-2 (only the last number increases by one).

My question is can a condition be added that checks if the last number in the set is a 10 (could be any number 1–10, 4-10, 20-10 etc) the code would move only that set down two cells instead of one cell. So as an example if cell P38 has a 1-10 the code would move it to cell P40 and the expected result would be 1-11. All other set of numbers would continue to move down one cell only.

If you have any questions please ask me.

Thank-you for any help.

Hi

This post can be closed i have solved the problem myself.
thank-you