Thread: Cocatenating two variables with a space in between
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Deecrypt Deecrypt is offline
external usenet poster
  
Posts: 20
Default Cocatenating two variables with a space in between
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

Reply With QuoteReply With Quote