standard function in userfunction?

L

Loranga

Aloha,

Im in the progress of learning VBA I have created some simple vb
functions but Im woundering how I inser standard excel function in m
"home made function".
In my function called funcBatch I divide the weiht with 50 and get th
result 104,9.
funcBatch = (dblWeight / 50)
Now I want to use the CEILING function to get the result to 105.

But how Can I do this in the VBA code?
funcBatch = ceiling((dblWeight / 50);1) dosent seems to work
 
R

Rog

The worksheet functions which can be accessed (and not all
of them can) need to be qualified with the
WorksheetFunction object - so to use ceiling you should
write :

WorksheetFunction.Ceiling

Rgds

Rog
 
Top