Thread: add 1 to the value in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default add 1 to the value in a cell
Hi pls123

With Sheets("Sheet1")
.Range("B5").Value = .Range("B5").Value + 1
End With


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"pls123" wrote in message ...
hi all !! good afternoon !!!

i want to remerciate the microsoft forum for the precious help.

i need this:

If "my.condition.true" Then
add 1 to the value of cell "b5"
End If

Ty all for interesting !!

Reply With QuoteReply With Quote