Using roundup() but on a whole spreadsheet instead of since cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bobmanuk - 08 May 2008 14:59 GMT

Hi,

I need to update a fairly large spreadsheet so that all numbers are rounded
up... using roundup()

Ive looked around and ive come to the conclusion i need to use VBA.

can anyone help?

thanks.

Matty

Reply to this Message

Bob Phillips - 08 May 2008 16:45 GMT

For Each cell In ActiveSheet.UsedRange

If Not cell.HasFormula Then

If cell.Value <> "" Then

cell.Value = Application.RoundUp(cell.Value, 0)
End If
End If
Next cell

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi,
>
[quoted text clipped - 9 lines]
>
> Matty

Reply to this Message