Hi,
I'm wondering if anyone knows the concise coding to add a value onto an existing variable value, in essence just like when you hit copy, paste special, then add values onto the target cell. I've tried recording it, and it works through paste special, but the code looks really ugly, and the worksheet seems to jump around a bit (the macro works with numerous ranges throughout the workbook). I'm looking for a better way.
for instance I am after something like this, although i realise it looks a bit circular:
[code]range("variable").value = range("variable").value + range("another_variable").value[code]
This clearly doesnt work - Is it at all possible?
Thanks for your help.
Bookmarks