HI all,
I am needing a macro on a button click, that when pressed a cell on a different page is added by "x". Here is the part that I cant get to work, The button will be used on multiple pages and must run in the backround and stay on the same page. I wrote:
Sub pointone()
Dim x As Integer
Sheets("Data Sheet").Range("i7").Value = i7 + 0.01
End Sub
And this does what i need it to do, but replaces the cell with that amount and not add's it.
Can anyone help?
Kind regards,
Dean