Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A spreadsheet will not link to cells in another spreadsheet? | Excel Discussion (Misc queries) | |||
Set a range of cells for ROUNDUP | Excel Discussion (Misc queries) | |||
roundup by 16s | Excel Worksheet Functions | |||
Roundup for multiple cells | Excel Discussion (Misc queries) | |||
How do I ROUNDUP a Column of cells on a worksheet template? | Excel Worksheet Functions |