standard function in userfunction?
 

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

--
Message posted from http://www.ExcelForum.com

standard function in userfunction?
 

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

-----Original Message-----
Aloha,

Im in the progress of learning VBA I have created some
simple vba
functions but Im woundering how I inser standard excel
function in my
"home made function".
In my function called funcBatch I divide the weiht with
50 and get the
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.


---
Message posted from http://www.ExcelForum.com/

.