increasing cell values by a percentage

Hi there,

I need a code that would do the following.

I have selected some merged cells, i would like to increase the values of those merged cells by a certain percentage for ex. 5 percent.

The regular way of paste special/multiply wont work because its merged.

Is there another way with vba. ?

if possible to have an input box to enter the percentage.


Thanks

Maybe:

Please Login or Register  to view this content.

Try

Please Login or Register  to view this content.

Originally Posted by Kaper

Try:

Please Login or Register  to view this content.

In inputbox both
5%
and
0.05
are accepted

this "strange replace" is required as I vale localized version with comma as decimal separator. It could be that in US version it is not required

PS. I noticed after publishing John's code - it will probably (not tested) change empty cells into zeros. But on other hand it refers to Selection - indeed it is in your post, so please change usedrange to selection in the above code.

HI

is it possible to add to your code that i should not have to input the percentage symbol i should just input 5 or 10 etc ..