Add a Value to a Cell Q

[seanryanie]

Looking for some code that would apply a certain amount to each cell in a range. In my scenario I have a price list in B1 to D20, I want to add 20p to each cell. Is there a neat way to do this?

Thanks

 

[Claus Busch]

Hi,

Am Sun, 22 Sep 2013 11:19:57 -0700 (PDT) schrieb (e-mail address removed):

Looking for some code that would apply a certain amount to each cell in a range. In my scenario I have a price list in B1 to D20, I want to add 20p to each cell. Is there a neat way to do this?

write 0,2 in a empty cell => copy this cell => select B120 => Insert
=> Paste Special => Add


Regards
Claus B.

 

[isabelle]

write 1,2 for adding 20p

isabelle

Le 2013-09-22 14:25, Claus Busch a écrit :

Hi,

Am Sun, 22 Sep 2013 11:19:57 -0700 (PDT) schrieb (e-mail address removed):

In my scenario I have a price list in B1 to D20, I want to add 20p to
each cell. Is there a neat way to do this?