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

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

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

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



--
HTH

Bob

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

"bobmanuk" wrote in message
...
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