ThanksWith regard to mohadin and Fluff's suggestion to use the Ceiling function (referencing either WorksheetFunction or Application) , I just want to point out to those who might not be aware there is a VBA equivalent of the Excel CEILING.MATH function (like the CEILING function but has an option on how to deal with negative values) called Ceiling_Math (again, referencing either WorksheetFunction or Application) whose arguments are the same as the CEILING.MATH function.