| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace reference inside formula
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace reference inside formula
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" 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace reference inside formula
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Replace reference inside formula
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 m lately ;) As for Gary...No and no. But thanks! Anne Troy Wrote: Don't know why you need a macro, Malik. You only need to do Find/Replace, and then make sure it's looking in formulas. :) ******************* ~Anne Troy -- malik64 ----------------------------------------------------------------------- malik641's Profile: http://www.excelforum.com/member.php...fo&userid=2419 View this thread: http://www.excelforum.com/showthread.php?threadid=38866 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference text in a cell inside a formula to specify a sheet name | Excel Worksheet Functions | |||
| find and replace inside comments? | Excel Discussion (Misc queries) | |||
| How to replace a function with its resulting reference in a formula? | Excel Worksheet Functions | |||
| How to replace a function with its result or resulting reference in a formula? | Excel Worksheet Functions | |||
| Find and Replace formatting inside of a macro | Excel Programming | |||
![malik641[_18_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
