Thank you Mr Paul.
Regards
Eugene
On Mon, Nov 21, 2016 at 6:36 PM, Paul Schreiner
wrote:
> Yes:
>
> First, make sure the functions are defined as "public".
> As in:
> In Book1.xlsb:
> Public Function Test_Calc(iVal)
> Test_Calc = iVal + 10
> End Function
>
> In Book2, use:
> =Book1.xlsb!Tes
Yes:
First, make sure the functions are defined as "public".As in:In
Book1.xlsb:Public Function Test_Calc(iVal)Test_Calc = iVal + 10End Function
In Book2, use:=Book1.xlsb!Test_Calc(A2)
Paul-
“Do all the good you can,
By all the means you can,
In all the