Does anyone know how to bring in the Bessel Functions that can be used on the Excel Worksheets into Visual Basic code?
I've tried typing WorksheetFunction.BesselJ(x,n) but still it is not recognized by Visual Basic. Please Help.
Not all worksheet functions are available to Visual Basic. For a list of the ones that are, enter "list of worksheet functions available to visual basic" into the Answer Wizard in VB Help. A workaround is to enter the values and formulas into cells:
c1.Value = x
c2.Value = y
c3.Formula = "=Besselj(x,y)"
MyVar = c3.Value
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.