Concatenation

[Biff]

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

 

[Niek Otten]

Using " instead of "" it works fine for me

 

[Nigel]

try....

Selection.Value = "123" & Selection.Value

 

[Biff]

I removed one set of "" and it works if I select a single cell but I want to
do this for a range of cells.

Instead of doing this:

="123"&A1

copy down, then copy>paste special>values, then drag to column A.

Thanks!

Biff

 

[Bob Phillips]

Dim cell As Range
For Each cell In Selection
cell.Value = "123" & cell.Value
Next cell


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Biff]

Thanks, Bob!

Biff

Dim cell As Range
For Each cell In Selection
cell.Value = "123" & cell.Value
Next cell


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)