Add a Value to a Cell Q

  • Thread starter Thread starter seanryanie
  • Start date Start date
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
 
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?
Click to expand...

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


Regards
Claus B.
 
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):
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?
 
Back
Top