View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brandon[_4_] Brandon[_4_] is offline
external usenet poster
 
Posts: 5
Default Excel Macro Strings

Hello, I am trying to use the concatenate operator to
combine 3 different individual strings with numbers in
them into one string. Something like this:

month = xx
day = xx
year = xx

date = month & "/" & day & "/" & year

But this doesn't work. Is this the correct operator to
use for this kind of purpose and I am just using it
incorrectly? Or is there a whole other way and I am
missing something?