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" wrote in
message ...
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