How do I ROUNDUP an entire column of numbers?
 

I need to ROUNDUP an Excel column that contains 250 numbers. Is there a way
to do this without rounding up each cell individually?

How do I ROUNDUP an entire column of numbers?
 

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.
--
David Biddulph

"Yellow Elk" <Yellow wrote in message
...
I need to ROUNDUP an Excel column that contains 250 numbers. Is there a
way
to do this without rounding up each cell individually?

How do I ROUNDUP an entire column of numbers?
 

Try
Sub roundemup()
For Each c In Range("H2:H251")
c.Value = Application.RoundUp(c, 0)
Next c
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Yellow Elk" <Yellow wrote in message
...
I need to ROUNDUP an Excel column that contains 250 numbers. Is there a
way
to do this without rounding up each cell individually?

How do I ROUNDUP an entire column of numbers?
 

On Dec 24, 5:45 am, Yellow Elk <Yellow
wrote:
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