How can I delete 1 from the value of a cell when I press a Button.
 

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

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

How can I delete 1 from the value of a cell when I press a Button.
 

Thanks \ron, much appreciated

"Gary" wrote:

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