Thread: How can I delete 1 from the value of a cell when I press a Button.
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 How can I delete 1 from the value of a cell when I press a Button.
You can use this Gary
Range("A1").Value = Range("A1").Value - 1


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Gary" wrote in message ...
I am trying to create a stock / ordering sheet. When I press a button I want
the stock coloumn to delete 1 from the value in the stock cell. Every time I
try I get a circular refernce error.

Can Anyone help.

Gary


Reply With QuoteReply With Quote