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
|