Function code

[Jimbo1]

Hi Guys

Is there a way I can use the FInv worksheet function in the vb scrip
editor?

Cheers
Ji

 

[bplumhoff]

Hello,

Use
r = application.worksheetfunction.finv(...)

HTH,
Bernd

 

[Bob Phillips]

Jim,

like this using the example in help

application.FINV(range("A2"),range("A3"),Range("A4"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Duncan]

Jimbo,

use the syntax:

Application.WorksheetFunction.FInv

press open bracket at the end

Application.WorksheetFunction.FInv(

and then it should pop up and guide you through it, I dont know what
this function does so cannot help any further than that, but it asks
for argument 1, argument2, and so on. You must surely know what that
means as its a function you use but I dont.

If you post back and explain further how you want to manipulate the
return from this function then we can help further and put it in the
right context (maybe its RETURNVALUE = application.blah.etc all depends
on how you want to use this function and what for)

HTH

Duncan