View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Increasing easily the number in a cell.

Hi,
A simple macro will do this for you.
The following would be the simplest.

Sub Increment()
Range("A1").Value = Range("A1").Value + 1
End Sub

Assign a button or a short-cut key to the macro. Each time it runs, your
number will increase by 1.
I've assumed your number is in cell A1. Change the reference as necessary.

Regards - Dave.