Use string returning UDF in formula

Hello,

So, I've written a function in VBA which returns a cell address, for instance '$A$40'. I want to use this cell address in an array formula, but it returns 0.
When I put '$A$40' in the formula manually it returns the correct value, but when I put in 'MyFunction()' it returns blank.

EDIT: This is the formula:

Please Login or Register  to view this content.

Where 'FoolProof()' returns the cell address and Optional_Processes is a named range.