Running Worksheet Function in VBA

[thereuare]

Is this a valid line of code?

DivisionInteger = Application.WorksheetFunction.Quotient(CheckValue, BoxSize)

My program creates an error, with the variable DivisionInteger being empty, and the variables CheckValue and BoxSize having values (these two variables should be enough to create a value for DivisionInteger)

When i just try the Quotient Function in a cell with 2 numbers, it works fine.

Thanks.

 

[Swamp Thing]

Hi Ivan,
I'm wondering if you can access an add-in Function without setting the reference.. the way you can access a Sub procedure? I mean, using the filename & exclamation mark syntax?

 

[Ivan F Moala]

On 2002-08-24 22:05, Swamp Thing wrote:
Hi Ivan,
I'm wondering if you can access an add-in Function without setting the reference.. the way you can access a Sub procedure? I mean, using the filename & exclamation mark syntax?

Hi Swamp Thing,
Yes you can....as long as you have it loaded in.

<pre/>
Variable = Application.Run("ATPVBAEN.XLA!QUOTIENT", x, y)
</pre>

 

[Ivan F Moala]

On 2002-08-24 22:05, Swamp Thing wrote:
Hi Ivan,
I'm wondering if you can access an add-in Function without setting the reference.. the way you can access a Sub procedure? I mean, using the filename & exclamation mark syntax?

Hi Swamp Thing,
Yes you can....as long as you have it loaded in.

<pre/>
Variable = Application.Run("ATPVBAEN.XLA!QUOTIENT", x, y)
</pre>

 

[Swamp Thing]

Wow.. very counter-intuitive, but cool!

Thanks.