How to use Standard Excel function in VBA

**akabraha** · 08-24-2007, 03:26 PM

Hello,

I am trying to use standard excel function CEILING to round up. But I am getting an error: "Sub or Function not defined" - Help please


e = CEILING(10.6, 1)

In the above example, should get a result 11

Thanks in advance.
Anil

**BigBas** · 08-24-2007, 03:31 PM

Try

Worksheetfunction.Ceiling

Can you incorporate that at all?

**Leith Ross** · 08-24-2007, 03:33 PM

Hello Akabraha,

You need to prefix the Excel function with the WorsheetFunction statement like this...

e = ActiveSheet.WorksheetFunction.CEILING(10.6, 1)

Sincerely,
Leith Ross

**akabraha** · 08-24-2007, 03:50 PM

Thanks a lot BigBas and Leith Ross - you guys are so quick!!

 e = WorksheetFunction.CEILING(10.6, 1)

above code worked just fine.

 e = ActiveSheet.WorksheetFunction.CEILING(10.6, 1)

when I tried to add ActiveSheet as shown above, it gave me an error: "Object doesn't support this method or property"

Have a great weekend.

Thanks, Anil

How to use Standard Excel function in VBA

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How to use Standard Excel function in VBA

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions