VBA Roundup Worksheet Function

[Yogi150871]

Good Afternoon

I am very new to Macros and VBA, but understand a little about how they work, it is the substance I lack!

I have a spreadsheet full of figures in 3 neighbour columns (Cell range G2:I1459).
I want to run a macro that will round all of these figures to the nearest whole number. I have deduced that the worksheet function Roundup can be used, but cannot understand what needs to be the first argument in the brackets. This is what I have come up with so far:

Sub Roundup()
For Each Cell In Range("G2:I1459")
Cell = Application.Roundup(Cell, 0)
Next
End Sub

It seems a pretty simple one, but have trawled the forums with no success, hence starting a new thread.

Thanks in advance

 

[VoG]

Hi. This works

Sub Roundup()
Dim Cell As Range
For Each Cell In Range("G2:I1459")
Cell.Value = Application.Roundup(Cell.Value, 0)
Next
End Sub

 

[Yogi150871]

Thanks so much for your help!