help with afind replace and change of data amount from minus to postive and viceversa

[leanne2011]

Hi

I attach a test file, how can I find component "Unpaid Leave" for any employee with this pay component to then change the minus value to a plus and a plus value to a minus ?

I have done a before and after as to what I need my macro to do to help - in the test file attached.

In excel I would do a ctrl and find "Unpaid Leave" then an if statement : if (cell<0, cell * -1, active cell value) - but I don't know how to do this in vba ?

Thanks in advance for your help.
Leanne