I told you it was so simple I could not see it! Thanks, Dave! It works
perfectly now.

--
Pops Jackson


"Dave Peterson" wrote:

> Since rng (or rngA or rngB) are objects (they represent ranges--with all the
> range properties and methods), you need to use the Set statement:
>
> Set rng = rngb.find(...
>
>
>
> Pops Jackson wrote:
> >
> > I am attempting to use the following routine to identify all of the matches
> > between two columns. rngA contains the short-name data and rngB contains
> > text which includes one short-name within it. Once identified, the
> > short-name is to be pasted in the appropriate cell to the right of the text
> > containing it.
> >
> > In its present form, I can step through to "rng = rngB.Find...". at this
> > point comes the "Object variable or With block variable not set." I have
> > tried dozens of fixes which either only result in the same message or cause a
> > different one.
> >
> > The fix is probably so simple I cannot see it so I need some help. Any and
> > all suggestions will be appreciated.
> >
> > Thanks in advance,
> >
> > Jim
> > --
> > Pops Jackson
>
> --
>
> Dave Peterson
>