standard function in userfunction?

  • Thread starter Thread starter Loranga
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

index function in vba 3
User Defined Functions 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
excel spreadsheet functions written in vba 1
Force use of standard function 5
Functions in Excel macro 2
Summing Percentages 3
To SQL Expert: VBA Function that Calls SQL Query 3

Back
Top