The equivalent of Application.WorksheetFunction.RoundUp in VBA
jp
-
chossette9 Posted messages 6855 Registration date Status Contributor Last intervention -
chossette9 Posted messages 6855 Registration date Status Contributor Last intervention -
Bonjour,
I would like to know the equivalent of ROUNDUP in VBA for my formula
length = ((Application.WorksheetFunction.RoundUp(Q / (Sheets("tableau de données").Range("$B$3").Value), 0)) - 1) * (DIA / 10) * (Sheets("tableau de données").Range("$B$2").Value) + Q
Thank you
JP
Configuration: Windows XP / Internet Explorer 7.0
I would like to know the equivalent of ROUNDUP in VBA for my formula
length = ((Application.WorksheetFunction.RoundUp(Q / (Sheets("tableau de données").Range("$B$3").Value), 0)) - 1) * (DIA / 10) * (Sheets("tableau de données").Range("$B$2").Value) + Q
Thank you
JP
Configuration: Windows XP / Internet Explorer 7.0
1 answer
Hello,
a Google search with the terms 'round VBA', 3 seconds waiting for the results, 5 seconds searching through the links, and there you go.
Best regards.
--
This guy wasn't the brightest, as he was simple-minded.
a Google search with the terms 'round VBA', 3 seconds waiting for the results, 5 seconds searching through the links, and there you go.
Best regards.
--
This guy wasn't the brightest, as he was simple-minded.