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