Function code

[Jimbo1]

Hi Guys

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

Cheers
Jim

[[email protected]]

Hello,

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

HTH,
Bernd

[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




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

[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)

"Jimbo1" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>