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

Thanks

[Claus Busch]

Hi,

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

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 B1:D20 = Insert
= Paste Special = Add


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

[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 :

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 B1:D20 = Insert
= Paste Special = Add


Regards
Claus B.