alu
08-21-2009, 01:38 AM
Hi,
I would like to create a button that when pressed increases the vale of an adjacent cell by +1.
Currently I am using a macro that silently puts the existing value in another location applies =sum(cell + cell A1 //which contains the value 1) then copies it back.
This seems a very messy way of doing it. Does anyone have a cleaner simpler suggestion?
Thanks in advance all
Alu
edit: maybe a macro that will just run this formula '=sum(cell+1)'
I would like to create a button that when pressed increases the vale of an adjacent cell by +1.
Currently I am using a macro that silently puts the existing value in another location applies =sum(cell + cell A1 //which contains the value 1) then copies it back.
This seems a very messy way of doing it. Does anyone have a cleaner simpler suggestion?
Thanks in advance all
Alu
edit: maybe a macro that will just run this formula '=sum(cell+1)'