VBA - Problem with adding variable to formula

[WednesdayC]

Hi All

Please can anyone help me.


I am trying to add 2 variables (strmonth and stryear) to a formula using VBA.

strmonth contains "DEC" and stryear contains "16"

The plan is to become a title for an email.

I have tried various permutations. Example

ActiveSheet.Cells(2, 6).FormulaR1C1 = "=RC[-3]" & strmonth & stryear

This doesn't work and no does anything else I have tried. I assume I need an & somewhere, but can't see how.

Many thanks in advance.


Regards

Wednesday

 

[BarryL]

maybe:

ActiveSheet.Cells(2, 6).Value = Range("C2").Value & strmonth & stryear

 

[RoryA]

If you really want a formula, you'd need something like this:

ActiveSheet.Cells(2, 6).FormulaR1C1 = "=RC[-3]&""" & strmonth & stryear & """"

 

[WednesdayC]

If you really want a formula, you'd need something like this:

ActiveSheet.Cells(2, 6).FormulaR1C1 = "=RC[-3]&""" & strmonth & stryear & """"

Hi Rory

Thank you so much - just what I wanted.

Have a great Xmas.

Regards
Wednesday

 

[RoryA]

Glad to help, and merry Christmas to you too.