I need a macro that scans the selected cells fo
"[ClinPath1.xls]ClinPath!" and replaces them with " 'Immuno-Assay'! "
There are multiple "[ClinPath1.xls]ClinPath!" in each cell and I nee
each one replaced with " 'Immuno-Assay'!".

If I had a Macro to do this. It would knock off a good 3 Hours of m
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 t
make one in the mean-time

--
malik64

-----------------------------------------------------------------------
malik641's Profile: http://www.excelforum.com/member.php...fo&userid=2419
View this thread: http://www.excelforum.com/showthread.php?threadid=38866