View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jeff Standen[_2_] Jeff Standen[_2_] is offline
external usenet poster
 
Posts: 56
Default Loop to add +1 in cell?

Range("a1").value=range("a1").value + 1

Is that what you mean?

Jeff

"bxvang" wrote in
message ...

Okay, so what that code does is...

2 cells A5 and B5

You click on either cell and it adds +1 to the previous number in the
cell.

Is there a way to assign that code to a button? Thanks for your help.
It is much appreciated.


--
bxvang
------------------------------------------------------------------------
bxvang's Profile:
http://www.excelforum.com/member.php...o&userid=35135
View this thread: http://www.excelforum.com/showthread...hreadid=548932