Manipulating Round() function in VBA - MrExcel.com

-3 = nearest 1000. You can also use "ceiling" formala for odd rounding, or roundup or ...

www.mrexcel.com