Hello,
I am trying to use Harlan Groves PULL UDF. I have inserted a module in my
work book and added the code verbatim as posted on his site. My indirect
function is:
=INDIRECT("'[FFPSTotal "& YEAR &".xls]" &$R9&"'!B$13")
This works of course only when FFPS is open. How do I modify the formula to
incorporate PULL. I have tried PULL("'[FFPSTotal "& YEAR &".xls]"
&$R9&"'!B$13"), and get #REF!
Thanks!