Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Work-around for lack of " ' " before/after sheet names with no spaces
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Allow "List" to work in a locked sheet | Excel Worksheet Functions | |||
Stop the "Personal" sheet from popping up every time I open a work | Excel Discussion (Misc queries) | |||
Sub to strip away "Sheet" prefix from names | Excel Programming | |||
pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
Backup to specific folder if workbook names begins with "NSR" or "MAC" | Excel Programming |