Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a Value to a Cell Q
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a Value to a Cell Q
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add a Value to a Cell Q
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Programming | |||
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |