Posted to microsoft.public.excel.programming

Maxi[_2_]

external usenet poster

Posts: 94

concatenate with vba

Hi!

I have first name in A1 and last name in A2

When I use the syntax
Sheets("Extract").Range("A" & ERow).Value = ActiveCell.Offset(0,
-2).Value & ActiveCell.Offset(0, -3).Value

Value of ERow is 1
Offset -2 is the first name
Offset -3 is the last name

VBA does not support "&" to get both the names in one cell of a
different sheet?

Please help

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
Concatenate If	Novice	Excel Worksheet Functions	4	July 9th 09 10:05 PM
=CONCATENATE() help!	shfcook	Excel Worksheet Functions	4	September 14th 05 11:01 AM
I know how to concatenate ,can one de-concatenate to split date?	QUICK BOOKS PROBLEM-	New Users to Excel	1	July 26th 05 05:07 PM
CONCATENATE-1	AYPCN	Excel Programming	1	March 9th 05 09:41 PM
CONCATENATE-1	AYPCN	Excel Programming	0	March 9th 05 09:15 PM

All times are GMT +1. The time now is 09:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us