Hi Guys

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

Cheers
Ji

--
Jimbo
-----------------------------------------------------------------------
Jimbo1's Profile: http://www.excelforum.com/member.php...fo&userid=3063
View this thread: http://www.excelforum.com/showthread.php?threadid=56141

Hello,

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

HTH,
Bernd

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)

"Jimbo1" wrote in
message ...

Hi Guys

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

Cheers
Jim


--
Jimbo1
------------------------------------------------------------------------
Jimbo1's Profile:
http://www.excelforum.com/member.php...o&userid=30637
View this thread: http://www.excelforum.com/showthread...hreadid=561415

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




Jimbo1 wrote:

Hi Guys

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

Cheers
Jim


--
Jimbo1
------------------------------------------------------------------------
Jimbo1's Profile: http://www.excelforum.com/member.php...o&userid=30637
View this thread: http://www.excelforum.com/showthread...hreadid=561415