| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Asin" doesn't work in VB for Excel macros
I get the error message "sub or function not defined" when I try to use ASIN
in VBA Excel. Works OK in the worksheet, asin gets changed to Asin when I type it into VBA and Asin is listed as a function for VBA in the help but it doesn't work? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Asin" doesn't work in VB for Excel macros
Try application.asin()
Some worksheet functions have equivalent VBA functions. Some don't. Some worksheet functions can be used in VBA (like this one). Alan wrote: I get the error message "sub or function not defined" when I try to use ASIN in VBA Excel. Works OK in the worksheet, asin gets changed to Asin when I type it into VBA and Asin is listed as a function for VBA in the help but it doesn't work? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
"Asin" doesn't work in VB for Excel macros
try this:
application.worksheetfunction.asin(...) -- www.alignment-systems.com "Alan" wrote: I get the error message "sub or function not defined" when I try to use ASIN in VBA Excel. Works OK in the worksheet, asin gets changed to Asin when I type it into VBA and Asin is listed as a function for VBA in the help but it doesn't work? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =SUBSTITUTE(C4,"~?#","") will this work to remove multiple string | Excel Worksheet Functions | |||
| "excel "macros may be disabled" message using an xlam file | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| "openinf file..."ENABLE MACROS...DISABLE MACROS" | Excel Discussion (Misc queries) | |||
| pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
Hybrid Mode
