Quite often we need to round a number up to the nearest n in VBA. The default Round worksheet formula performs a bankers round i.e. to the nearest even number so you can't be sure it will round up.
Usually I head for Google to find the latest funky way of doing it but as you can see there a a myriad of complicated and confusing answers, so I decided to write my own very simple method:
Function RoundUpToN(numToRound As Double, nearestValue As Long) As Long
RoundUpToN = Application.Ceiling(num, nearestValue)
Hope this helps.