How to use Standard Excel function in VBA

[akabraha]

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

Please Login or Register  to view this content.

In the above example, should get a result 11

Thanks in advance.
Anil

[BigBas]

Try

Please Login or Register  to view this content.

Can you incorporate that at all?

[Leith Ross]

Hello Akabraha,

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

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[akabraha]

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

Please Login or Register  to view this content.

above code worked just fine.

Please Login or Register  to view this content.

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