How can i call a function on another worksheet

[Jorge Ribeiro]

Hello

Supose that i have a worksheet called sheetTst that has a function called
GetNumber

In my excel app i create severeal worksheets dinamically of that type.
How can i call GetNumber of a worksheet i have just created?

regards

Jorge

 

[Bob Phillips]

Functions aren't on a worksheet, they are used on a worksheet. You should be
able to call it from any sheet.

 

[The Code Cage Team]

Do you mean you want the code for the CALL adding to the worksheet cod
module? or populating a cell with the function?, if you store the UDF i
a standard module then you can simply use the function on any workshee

Functions aren't on a worksheet, they are used on a worksheet. Yo
should be
able to call it from any sheet.

--
__________________________________
HTH

Bob

message

--
The Code Cage Tea

Regards,
The Code Cage Team
'The Code Cage' (http://www.thecodecage.com