Round a Column of Numbers to a Specific List

Hi Brandon,

Change this

Set ChangeRange = Range(sColumnLetter & "2", Cells(Rows.Count, sColumnLetter).End(xlUp))

to this:

Set ChangeRange = Range(sColumnLetter & "7", Cells(Rows.Count, sColumnLetter).End(xlUp))

The "2" represented the first row of data you want to change. In your workbook it starts in row 7. Thanks!

If you still have my project . . .

I'm getting an erroneous couple 400's in E3 and E4 once doing the macro by button click. Is there anyway to stop these from coming up without hiding them? Efficient and Clean Code for the Win! :-)