Thread: Concatenation
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default Concatenation

Using " instead of "" it works fine for me

--
Kind regards,

Niek Otten

"Biff" wrote in message
...
Hi Folks!

Trying to figure out how to concatenate a string to each cell in a range
of cells.

I tried this:

Selection.Value = ""123"" & Selection.Value

Of course that did not work!

I guess VBA concatenation is different from worksheet concatenation.

Thanks!

Biff