|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 14th, 2005, 11:13 AM
|
|||
|
|||
I need to increase a number which is held in a cell by 1
How do i increase a cell which has a number in it, eg, cell a8 has 4
i want to run a If statment that looks at another cell and if true i want cell a8 to increse to 5 
|
|
#2
January 14th, 2005, 12:07 PM
|
|||
|
|||
|
You need VBA.
The code is simple in itself (Range("A1").Value = Range("A1").Value + 1), but what will trigger the addition to happen. -- HTH ------- Bob Phillips "Steve" wrote in message ... How do i increase a cell which has a number in it, eg, cell a8 has 4 i want to run a If statment that looks at another cell and if true i want cell a8 to increse to 5
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | [email protected] | New Users | 2 | January 6th, 2005 07:18 AM |
| IF only.....IF only.... | SmokingMirror | Worksheet Functions | 8 | August 7th, 2004 07:37 PM |
| Counting number of characters in cell | saturnin02 | General Discussion | 4 | August 3rd, 2004 04:09 AM |
| Write Common Number into Blank Cell | Max | Worksheet Functions | 4 | November 27th, 2003 11:44 PM |
| Increase maximum capacity of text in cell | Joanne | Worksheet Functions | 2 | November 20th, 2003 07:09 PM |
Linear Mode
