Hi AB33,
Apologies for not sending the full file, it simply cannot fit (over 70Mo).
So I've verified everything once again and the issue keeps occuring.
Effectively I run the macro once and everything is fine. I have one column at the end that checks whether the line balances out and it does. I run the macro a second time and while nothing should change (because all blanks are filled and all the arguments shouldn't execute), all my numbers change (but it is too difficult for me to isolate to one particular column because of the sheer volume of data).
So my question is, is there anything I can add to the below code so each "argument" (probably not using the right terminology) does not run if the conditions aren't met (eg don't do anything to column H if you can't find blank cells).
THank you
Bookmarks