macro to multiply all constant numbers of column D of all worksheets in the workbook & rounded off result upto 2 decimal no

[Yogesh Joshi]

Hi all of you

I'm very new to the macro world..!!

I need a macro to multiply all constant numbers of column D of all worksheets in the workbook & rounded off result upto 2 decimal no.

Any help will be much appreciated.

Thanks in advance

 

[Yogesh Joshi]

multiplication can by done any no. Like 1.03 or 1.07.

 

[Yogesh Joshi]

I have tried below code which is helping me out with single sheet result but I have so many sheets in the workbook can you help me through to get the result of all sheet at one go..


Sub Macro5()

On Error Resume Next

Set C = Range("d1:D500").Cells.SpecialCells(xlCellTypeConstants)

For Each cc In C

cc.Value = Format(cc.Value * 1.03, "#.00")


Next

End Sub


Many Many Thanks in advance...!!

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: macro to multiply all constant numbers of column D by 1.03 of all worksheets in the workbook & rounded off result upto 2 decimal no.
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Yogesh Joshi]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: macro to multiply all constant numbers of column D by 1.03 of all worksheets in the workbook & rounded off result upto 2 decimal no.
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

thanks to clarify that I will surely do that from my next post onward.

 

[Yogesh Joshi]

I have posted the same question in other forum too & I got the solution which can be reached from following link....

http://https://chandoo.org/forum/th...k-rounded-off-result-upto-2-decimal-no.47901/

 

[Yogesh Joshi]

I have posted the same question in other forum too & I got the solution which can be reached from following link....

http://https://chandoo.org/forum/th...k-rounded-off-result-upto-2-decimal-no.47901/

Check the following link for the solution ...

macro to multiply all constant numbers of column D by 1.03 of all worksheets in the workbook & rounded off result upto 2 decimal no.

Hi all of you I'm very new to the macro world..!! I need a macro to multiply all constant numbers of column D by 1.03 of all worksheets in the workbook & rounded off result up to 2 decimal no. I have tried below code which is helping me out with single sheet result but I have so many sheets...

chandoo.org