The below code does not work but I think I just need a small tweek.
Simply want to display the values of two variables in the same cell but
with a space in between.


ActiveCell.FormulaR1C1 = "=CONCATENATE(" & userMonthName & " " &
userYearName & ")"

Kind regards
Khurram

Hi,

You need to double up on your quotes.

ActiveCell.FormulaR1C1 = "=CONCATENATE(" & userMonthName & _
""" """ & userYearName & ")"

Cheers
Andy

Deecrypt wrote:
> The below code does not work but I think I just need a small tweek.
> Simply want to display the values of two variables in the same cell but
> with a space in between.
>
>
> ActiveCell.FormulaR1C1 = "=CONCATENATE(" & userMonthName & " " &
> userYearName & ")"
>
> Kind regards
> Khurram
>

Khurrram,

ActiveCell.Value = userMonthName & " " & userYearName

HTH,
Bernie
MS Excel MVP


"Deecrypt" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> The below code does not work but I think I just need a small tweek.
> Simply want to display the values of two variables in the same cell but
> with a space in between.
>
>
> ActiveCell.FormulaR1C1 = "=CONCATENATE(" & userMonthName & " " &
> userYearName & ")"
>
> Kind regards
> Khurram
>

Thank you all
The double quoted idea didnt work, however thank you for pointing out
that a formula is not required and a simple .Value function could be
used. It works and I appreciate the help.

Cheers
Deecrypt

John Bundy wrote:

> You don't have to place a formula there:
> Cells(1, 1) = "(" & userMonthname & " " & userYearname & ")"
>
> check your other post as well
> --
> -John
> Please rate when your question is answered to help us and others know what
> is helpful.
>
>
> "Deecrypt" wrote:
>
> > The below code does not work but I think I just need a small tweek.
> > Simply want to display the values of two variables in the same cell but
> > with a space in between.
> >
> >
> > ActiveCell.FormulaR1C1 = "=CONCATENATE(" & userMonthName & " " &
> > userYearName & ")"
> >
> > Kind regards
> > Khurram
> >
> >

Thank you all
The double quoted idea didnt work, however thank you for pointing out
that a formula is not required and a simple .Value function could be
used. It works and I appreciate the help.

Cheers
Deecrypt

John Bundy wrote:

> You don't have to place a formula there:
> Cells(1, 1) = "(" & userMonthname & " " & userYearname & ")"
>
> check your other post as well
> --
> -John
> Please rate when your question is answered to help us and others know what
> is helpful.
>
>
> "Deecrypt" wrote:
>
> > The below code does not work but I think I just need a small tweek.
> > Simply want to display the values of two variables in the same cell but
> > with a space in between.
> >
> >
> > ActiveCell.FormulaR1C1 = "=CONCATENATE(" & userMonthName & " " &
> > userYearName & ")"
> >
> > Kind regards
> > Khurram
> >
> >