If a cell contains "CR" then look for a value to the left and change it to negative.

[pasqualebaldi]

I have a code already that looks for the value "CR" and changes the cell to the left of it. But I am going to have different workbooks where the value I need to change to a negative is not one cell to the left.
Some are four cells to the left, and some are 3... and so on. So I need this code to change the first cell to the left that contains a value.

To sum it up: If a cell equals "CR" then continue to look left for a value and change that value to a negative. Then delete the "CR" value.

Here is my current code:

Please Login or Register  to view this content.

Thank you

[Kaper]

1) probably B:BA Range would be enough (if CR if for some reason in A you do not change anything left from it anyway)

2) I'd look left from the c Range for appropriate cell - sth like:

Please Login or Register  to view this content.

(try it - not tested)

[Kaper]

PS. If you expect multiple CRs Add

Please Login or Register  to view this content.

at the beginning of the code

PS2. Is this

Please Login or Register  to view this content.

really needed? I doubt. try commenting it out.

[pasqualebaldi]

1) probably B:BA Range would be enough (if CR if for some reason in A you do not change anything left from it anyway)

2) I'd look left from the c Range for appropriate cell - sth like:

Please Login or Register  to view this content.

(try it - not tested)

This code is working out great! Thank you very much for your help!