I have a worksheet that is working great but in column "T" of worksheet "Nambucca_October 2011" the array formula returns a "Blank" where it should return "Text". The same code works in other colored cells in row (5) but not in Column "T", the macro places the formula in the colored cells.
I would like the code to return a "Blank" only if no data is available. In this test worksheet I have added data for testing. The worksheet "HardCopyOfMacro" shows the code with the line of code causing the problem "highlighted".
Can someone identify any issues and fix them.