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 |
All times are GMT +1. The time now is 02:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com