Add a Value to a Cell Q

S

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
 
C

Claus Busch

Hi,

Am Sun, 22 Sep 2013 11:19:57 -0700 (PDT) schrieb [email protected]:
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?
Click to expand...

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


Regards
Claus B.
 
I

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 [email protected]:
Click to expand...

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?
 
Top