Never mind, just read the rest of the text, apologies.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Ken Wright" <ken.wright@NOSPAMntlworld.com> wrote in message
news:%23s5nrfAMFHA.3844@TK2MSFTNGP14.phx.gbl...
> Have you considered just using Autofilter?
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> --------------------------------------------------------------------------
--
> It's easier to beg forgiveness than ask permission :-)
> --------------------------------------------------------------------------
--
>
> "Rod" <Rod@discussions.microsoft.com> wrote in message
> news:9CF34D0E-3F8A-4EA5-A6CF-B440AC24062E@microsoft.com...
> > How can I have excel:
> > 1) search a specific row, e.g R4:R500 and for every occurance of a
> non-blank
> > cell
> > 2) bring back what corresponds to that row in col D?
> >
> > Thanks
>
>