Y
Yellow Elk
I need to ROUNDUP an Excel column that contains 250 numbers. Is there a way
to do this without rounding up each cell individually?
to do this without rounding up each cell individually?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
Just copy the ROUNDUP formula down the column. Select the cell, select the
bottom right-hand corner and it will turn into a square "fill handle" which
you can drag down. If your formula is in a cell adjacent to the column with
the data, if you double-click the fill handle it will fill down the column
as far as the data stretches.
bottom right-hand corner and it will turn into a square "fill handle" which
you can drag down. If your formula is in a cell adjacent to the column with
the data, if you double-click the fill handle it will fill down the column
as far as the data stretches.
D
Don Guillett
Try
Sub roundemup()
For Each c In Range("H2:H251")
c.Value = Application.RoundUp(c, 0)
Next c
End Sub
Sub roundemup()
For Each c In Range("H2:H251")
c.Value = Application.RoundUp(c, 0)
Next c
End Sub
D
D.
I need to ROUNDUP an Excel column that contains 250 numbers. Is there a way
to do this without rounding up each cell individually?
This is another option,
probably similar to Ron's
loops through column G and changes rounds up the value
Sub RoundUpCells()
Dim TheRange As Range
Dim TheCell As Range
Set TheRange = Range("G1", Range("G65536").End(xlUp))
For Each TheCell In TheRange
TheCell = Application.RoundUp(TheCell, 2)
Next TheCell
End Sub