Formula to Replace or eliminate any sheetname(s) in formula string

E

EagleOne

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
 
Top