Excel VBA: How to manipulate a cell/range address within a UDF | Windows Secrets Lounge

However it appears that the putting the Named Range or a cell address as the function parameter transfers the value contained in the cell to the function, rather than the cell/named range address, consequently the result returned by the function is #VALUE

windowssecrets.com