Hi,

I was trying to use a worksheet function in the VBA module and it isn't
working.

I type

Dim x as double

x = Application.Int(4.03)

and I get an error. Are we unable to use some worksheet functions in VBA?

Thanks for your help

Jeff,

Just take off the "Application" part. Like this:

Dim x As Double

x = Int(4.03)

Mark

"Jeff" wrote:

Hi,

I was trying to use a worksheet function in the VBA module and it isn't
working.

I type

Dim x as double

x = Application.Int(4.03)

and I get an error. Are we unable to use some worksheet functions in VBA?

Thanks for your help

INT is builtin to VBA, so the worksheet function isn't available. Use
x=int(4.03)

"Jeff" wrote in message
...
Hi,

I was trying to use a worksheet function in the VBA module and it isn't
working.

I type

Dim x as double

x = Application.Int(4.03)

and I get an error. Are we unable to use some worksheet functions in VBA?

Thanks for your help