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

[bobmanuk]

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

 

[Bob Phillips]

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)