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
I have two open workbooks A and B, in my system, and I like to use the
function available in Workbook A from Workbook B.
Is it possible.
Regards
Eugene
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
