Posted to microsoft.public.excel.programming

Biff

external usenet poster

Posts: 1,688

Concatenation

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenation	Vic	Excel Discussion (Misc queries)	5	October 22nd 09 05:57 PM
Concatenation help	Naresh	Excel Worksheet Functions	4	September 30th 09 12:50 AM
Concatenation	orquidea	Excel Discussion (Misc queries)	6	January 11th 08 07:19 PM
Concatenation	Ken	Excel Discussion (Misc queries)	1	April 12th 06 11:26 AM
Concatenation	Jim Cone	Excel Programming	0	October 31st 04 01:17 AM

All times are GMT +1. The time now is 07:51 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us