| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to Replace or eliminate any sheetname(s) in formula string
2003
Using this code: WorksheetFunction.Trim(myCell.Formula) Like "*-#*" a Sheet Name like "1-0000" or "9-20-2006" triggers a "find" or "True." I do not want a "find" or "true" when the "*-#*" is because of the contents of a sheet name. Any ideas how to either null all sheet names (and there could be many all with varying lengths) in "myCell.Formula" OR how to Replace all sheet names with i.e. an x or whatever? TIA EagleOne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| How do I replace numbers in a value NOT a formula? | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Linear Mode
