Thread: Cocatenating two variables with a space in between
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
  
Posts: 5,441
Default Cocatenating two variables with a space in between
Khurrram,

ActiveCell.Value = userMonthName & " " & userYearName

HTH,
Bernie
MS Excel MVP


"Deecrypt" wrote in message
ps.com...
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