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