If Range is Blanok Then...

I don't know what I'm doing wrong but this simple function isn't working.

I'm trying to do:

Please Login or Register  to view this content.

Please note everything in DefCol is a formula...

Maybe

Please Login or Register  to view this content.

I've looked at that method but it's really inefficient for me, basically if it finds a value returned from the formula in that range it needs to do something different to if it doesnt find anything...

What type of data is returned by the formula?

Numbers (0.304) for example.

Two methods that come to mind

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The first method uses an array formula within the code so with a large range could be slow to process.