Addition using macros

[johngio]

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

 

[Scott Huish]

Try this:

findit.Offset(1, 0) = Range("G15") + Range("Q15")

 

[johngio]

Thanks

It works!!