ROUNDUP DATA HELP

kshora

Board Regular
Joined
Aug 2, 2006
Messages
211
I have a huge data in my excel sheel and want to ROUNDUP all the data to the multiple of 10. How do I do it all together

Thanks and regards

kshora
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Dim c As Range, rng

Set rng = Worksheets("Sheet1").Range("A1:C10")

For Each c In rng


c = Application.WorksheetFunction.Ceiling(c, 10)
Next c
 
Upvote 0
thanks for the reply, however I did not understand how exactly to do it. I am not an expert, just working in excel
 
Upvote 0
Start recording a macro, then stop recording.
This will give you an empty macro, just paste the code between the Sub/end sub lines of the macro

Run the macro.

The code will round up all values in the range A1:c10 on Sheet1 to multiples of 10
 
Upvote 0
I tried but it comes up with runtime error and highlights "c = Application.WorksheetFunction.Ceiling(c, 10) " in yellow.

What do I do?
 
Upvote 0
Excel 2003

I did change the range to D6:D75 and changed the "sheet1" to "TMK Motorized impeller" same name as my worksheet.

Did this create a problem?
 
Upvote 0
It worked, thank you very much.

I did not do anything different, it first worked on a new work book and than on my worksheets

Thanks once again
 
Upvote 0
Hi I am back

when i choose a range with all integers the macro runs fine, however I have lots of ---- (dashes) within the range and it gives the error again when I include the ---- in the range. I cannot romove the ---- as it will creat big problems for me.
Is there any way I can achieve the rounding to multiple 10 without removing the ----

Thanks and regards
 
Upvote 0

Forum statistics

Threads
1,216,310
Messages
6,130,006
Members
449,552
Latest member
8073662045

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top