I think I know, why and I should have been clearer in my explination...

The table that is copied in the range "I6:P18" has formulas in each cell so it is blank if certain conditions aren't met and so it can calulate the various codes and values.

So I think the code would need to refer to cells with value "" rather than just empty cells

Sorry I hope this clears my poor explination up.