O
ozcarb
I have a workbook with three macros that spontaneously change if I change
worksheet names, adding single quotes in the middle of a string that causes
the macro to blow up. Is there a way to prevent this? I am using Excel 2003
SP2. The string that blows up is:
"=Zone1!R[-4]C+Zone2!R[-4]C+Zone3!R[-4]C+Zone4!R[-4]C+Zone5!R[-4]C+Zone6!R[-4]C+Zone7!R[-4]C+Zone8!R[-4]C+Zone9!R[-4]C+Zone10!R[-4]C"
Last time the change was this: +'Zone 5', so it included a space in the
middle of the spontaneous change.
worksheet names, adding single quotes in the middle of a string that causes
the macro to blow up. Is there a way to prevent this? I am using Excel 2003
SP2. The string that blows up is:
"=Zone1!R[-4]C+Zone2!R[-4]C+Zone3!R[-4]C+Zone4!R[-4]C+Zone5!R[-4]C+Zone6!R[-4]C+Zone7!R[-4]C+Zone8!R[-4]C+Zone9!R[-4]C+Zone10!R[-4]C"
Last time the change was this: +'Zone 5', so it included a space in the
middle of the spontaneous change.