VBA Functions Undefined

  • Thread starter Thread starter James O. Thompson
  • Start date Start date
J

James O. Thompson

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
 
That is service. I sent my question only an hour or so ago.

Indeed that fixes the problem.

Thanks,

Jim Thompson
 
Back
Top