is there any order to the cells that need to be changed? are there other
sells that have the original string in them?

--


Gary


"malik641" <[email protected]> wrote in
message news:[email protected]...
>
> I need a macro that scans the selected cells for
> "[ClinPath1.xls]ClinPath!" and replaces them with " 'Immuno-Assay'! ".
> There are multiple "[ClinPath1.xls]ClinPath!" in each cell and I need
> each one replaced with " 'Immuno-Assay'!".
>
> If I had a Macro to do this. It would knock off a good 3 Hours of my
> time!!
>
> So any help is appreciated.
>
> I'm still a novice at VBA, but I have a book to help me and I'll try to
> make one in the mean-time.
>
>
> --
> malik641
>
>
> ------------------------------------------------------------------------
> malik641's Profile:
> http://www.excelforum.com/member.php...o&userid=24190
> View this thread: http://www.excelforum.com/showthread...hreadid=388666
>