Give this a try:
![]()
Sub roundNumbers() Application.ScreenUpdating = False Dim rng As Range For Each rng In Range("B:B") If rng.Value <> "" Then rng.Value = Round(rng, 0) Next rng Application.ScreenUpdating = True End Sub
Give this a try:
![]()
Sub roundNumbers() Application.ScreenUpdating = False Dim rng As Range For Each rng In Range("B:B") If rng.Value <> "" Then rng.Value = Round(rng, 0) Next rng Application.ScreenUpdating = True End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks