Thread
:
Work-around for lack of " ' " before/after sheet names with no spaces
View Single Post
#
4
Posted to microsoft.public.excel.programming
Tim
external usenet poster
Posts: 145
Work-around for lack of " ' " before/after sheet names with no spaces
You could search each formula for the varios sheet names - if found then
check if they are surrounded by '' - if not then do a replace to replace the
sheetname with "'" & sheetname & "'"
Tim
wrote in message
...
To be more clear,
What the procedures use is essentially ActiveCell.Formula. Of course, the
formulas may have a link
to within-the-same sheet, to amother sheet same Wb, or to another Wb.
To change the sheet names would be overkill and fraught with potential
problems.
What I may need to do is stuff the string myString =
ActiveCell.Formula.with " ' " What is the
best approach?
EagleOne
wrote:
2003/2007
Have a number of procedures that rely upon sheet names being encapsulated
like
'Sheet Name'!Cellref . Currently, if a sheetname has no spaces then
SheetName!CellRef.
My proceedures rely upon finding the " ' " and/or the " '! "
Because of the (recent?) change, I have thought of temporairly
concatenating a "space" + some Char
to the end of each sheetname to force the issue then removing the "space"
+ some Char later in the
code. Of course, there is the issue of the sheetname currently being at a
limit length of 31 and
what to do then?
Any thoughts of other workarounds??????
EagleOne.
Reply With Quote
Tim
View Public Profile
Find all posts by Tim