I'm using Excel 2000 VBA but all references to functions in a VB program
come up as undefined. e.g., Asin(). Such references directly in a
spreadsheet cell work properly. I'm pretty sure I need to set a reference
to some object library but don't know which.

Any help,

Jim Thompson

Hi,

You need to remind VB that it's a worksheet function

myvalue=worksheetfunction.Asin(.....

Mike

"James O. Thompson" wrote:

I'm using Excel 2000 VBA but all references to functions in a VB program
come up as undefined. e.g., Asin(). Such references directly in a
spreadsheet cell work properly. I'm pretty sure I need to set a reference
to some object library but don't know which.

Any help,

Jim Thompson

That is service. I sent my question only an hour or so ago.

Indeed that fixes the problem.

Thanks,

Jim Thompson

"Mike H" wrote in message
...
Hi,

You need to remind VB that it's a worksheet function

myvalue=worksheetfunction.Asin(.....

Mike

"James O. Thompson" wrote:

I'm using Excel 2000 VBA but all references to functions in a VB program
come up as undefined. e.g., Asin(). Such references directly in a
spreadsheet cell work properly. I'm pretty sure I need to set a
reference
to some object library but don't know which.

Any help,

Jim Thompson