Hi all,
Very simple problem. I am trying to add a couple of values in a macro, however I cannot figure out the format to get it to work. Here is a part of the formula:
findit.Offset(1, 0).Value = Range("G15").Value
I would like to add Q15 to this result, so something like:
findit.Offset(1, 0).Value = Range("Q15+G15").Value
However, I don't know how to get VBA to recognise this.
Any simple pointers?
Cheers
John
Very simple problem. I am trying to add a couple of values in a macro, however I cannot figure out the format to get it to work. Here is a part of the formula:
findit.Offset(1, 0).Value = Range("G15").Value
I would like to add Q15 to this result, so something like:
findit.Offset(1, 0).Value = Range("Q15+G15").Value
However, I don't know how to get VBA to recognise this.
Any simple pointers?
Cheers
John