View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Loranga[_2_] Loranga[_2_] is offline
external usenet poster
 
Posts: 1
Default 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