i've defined a variable in vba and am now trying to get a function to call it. the value assigned to the variable is correctly being defined when i mouse over it, but i'm getting an error when the macro tries to run the function part of the code.
This is the array formula that i'm trying to...