Replace reference inside formula

[malik641]

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.

[Anne Troy]

Don't know why you need a macro, Malik. You only need to do a Find/Replace,
and then make sure it's looking in formulas.
*******************
~Anne Troy

www.OfficeArticles.com


"malik641" <malik641.1sh1j0_1121868747.1331@excelforum-nospam.com> wrote in
message news:malik641.1sh1j0_1121868747.1331@excelforum-nospam.com...
>
> 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
>

[malik641]

That........is...........simply...........AWESOME!!!
oh my God that help out like you wouldn't believe!

Thanks so much Anne...you're really on the ball with replying to me lately



As for Gary...No and no. But thanks!

Don't know why you need a macro, Malik. You only need to do a Find/Replace,
and then make sure it's looking in formulas.
*******************
~Anne Troy

[Gary Keramidas]

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" <malik641.1sh1j0_1121868747.1331@excelforum-nospam.com> wrote in
message news:malik641.1sh1j0_1121868747.1331@excelforum-nospam.com...
>
> 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
>