View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MSgtMark
 
Posts: n/a
Default VBA worksheet function

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