| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using macro recorder increment cell by one?
How do I increment a cell content by one using the Macro Recorder? That is 1
becomes 1+1=2, becomes 1+1+1=3. Each time the macro is run it increments the existing value by 1. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using macro recorder increment cell by one?
Select a cell and run:
Sub BumpIt() With ActiveCell ..Value = .Value + 1 End With End Sub -- Gary''s Student - gsnu200841 "Student2" wrote: How do I increment a cell content by one using the Macro Recorder? That is 1 becomes 1+1=2, becomes 1+1+1=3. Each time the macro is run it increments the existing value by 1. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using macro recorder increment cell by one?
Stick a Spin Button on your sheet.
Control Toolbox or Forms Toolbar. Gord Dibben MS Excel MVP On Tue, 24 Mar 2009 14:10:06 -0700, Student2 wrote: How do I increment a cell content by one using the Macro Recorder? That is 1 becomes 1+1=2, becomes 1+1+1=3. Each time the macro is run it increments the existing value by 1. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using macro recorder increment cell by one?
Thanks - easy to set up and works great!
"Gord Dibben" wrote: Stick a Spin Button on your sheet. Control Toolbox or Forms Toolbar. Gord Dibben MS Excel MVP On Tue, 24 Mar 2009 14:10:06 -0700, Student2 wrote: How do I increment a cell content by one using the Macro Recorder? That is 1 becomes 1+1=2, becomes 1+1+1=3. Each time the macro is run it increments the existing value by 1. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using macro recorder increment cell by one?
What is the procedure for entering this language and being able to run it?
Sorry, this is new territory for me. "Gary''s Student" wrote: Select a cell and run: Sub BumpIt() With ActiveCell .Value = .Value + 1 End With End Sub -- Gary''s Student - gsnu200841 "Student2" wrote: How do I increment a cell content by one using the Macro Recorder? That is 1 becomes 1+1=2, becomes 1+1+1=3. Each time the macro is run it increments the existing value by 1. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro recorder and formulas | Excel Discussion (Misc queries) | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| Macro recorder | Excel Discussion (Misc queries) | |||
| Change result of Macro Recorder | Excel Discussion (Misc queries) | |||
Linear Mode
