Replace reference inside formula

**malik641** · 07-20-2005, 09:25 AM

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 · 07-20-2005, 11:05 AM

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" <[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
>

Gary Keramidas · 07-20-2005, 11:05 AM

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
>

**malik641** · 07-20-2005, 11:23 AM

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!