Just this portion:

Note that names of the ranges are case sensitive.

I don't think that this is true. You may want to test once more.

Jim Cone wrote:

s,

Confusion is normal here...
Do not really understand your range designations,
however this works...
Set rngSrc = Application.Union(Range("BU"), Range("Affl"))
Note that names of the ranges are case sensitive.

Jim Cone

"shternm"
wrote in message

Sorry for the confusion: Both "BU" and "AFFL" are named ranges
specifying columns.
I would like to concatenate the two ranges.
For example:
*BU* * Affl * *Combined result to search
for*77 AX 77AX
63 MS 63MS
--
shternm

--

Dave Peterson