Paste Special Add Value - Neat Code?

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.

You can use pasteSpecial in your code, record a macro & then tidy it up

When you say variable do you mean a variable you have defined in vba or a cell value?

Maybe like this:

Please Login or Register  to view this content.

Dom

maybe

Please Login or Register  to view this content.