Hello,

I am trying to program my macro to find 9's and replace with 8's. However it's not quite that simple, I would like my macro to search the row and then replace from the end in. For example I would like my macro to replace for example:

0 9 9 1 1 0 1 0 9 9 9 9

With:

0 9 9 1 1 0 1 0 8 8 8 8

I.e. search from the end of the row if there are 6 9's at the end of the row replace with 6 8's, however those 9's earlier on in the row should remain unchanged.

Is this possible?

Thanks

Z