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 you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
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
 

kshora

Board Regular
Joined
Aug 2, 2006
Messages
211
thanks for the reply, however I did not understand how exactly to do it. I am not an expert, just working in excel
 

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
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
 

kshora

Board Regular
Joined
Aug 2, 2006
Messages
211

ADVERTISEMENT

I tried but it comes up with runtime error and highlights "c = Application.WorksheetFunction.Ceiling(c, 10) " in yellow.

What do I do?
 

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
Curious, works fine for me.

What version of Excel are you using ?
 

kshora

Board Regular
Joined
Aug 2, 2006
Messages
211

ADVERTISEMENT

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?
 

kshora

Board Regular
Joined
Aug 2, 2006
Messages
211
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
 

kshora

Board Regular
Joined
Aug 2, 2006
Messages
211
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
 

Forum statistics

Threads
1,136,263
Messages
5,674,710
Members
419,521
Latest member
Jasonnie

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
Top