Shoutbox

whats the best way to do 'add 1', to a cell selected/highlighted? basically everytime i click(or paste if makes things easier) on any cell i want the new value to be 'old value+1', so that i don't keep having to look what number is already in there, and then increasing it manually

Use a VBA macro...

Visual Basic code:

---

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Target = Target + 1
End Sub

---

Obviously just add a few conditions if Target is column A for example and if Target <> ""

EDIT: A bit more in depth:

Visual Basic code:

---

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target <> "" And ActiveCell.Column = 1 And ActiveCell.Row < 50 Then
        Target = Target + 1
    End If
End Sub

---

ActiveCell.Column uses numbers to represent columns instead of letters so A = 1, B = 2 etc.

knew i should have change my first post, want to be able to select multiple cells at once, have them all add 1.

Are all cells in the same column or row? It'd be easier if there was some sort of pattern

quote:

---

Originally posted by Spunky
Are all cells in the same column or row? It'd be easier if there was some sort of pattern

---

no, quite random spread

well 8 colums, 18 rows, but could be any selection of the cells

edit:
altho could live with select the cells row by row if it makes it easier/possible

It seams easier to make a hotkey,
Select the cells, press the hotkey en let the hotkey print Selection.Count to a specific cell...