Problem with - sign in sheet name??
I have code that will get a range method failed error when trying to
execute the statement:
x=range(s & i) where s="Brazil-008.ord" and i is any value. The
Brazil-008.ord tab (worksheet) does exist. If I change the salur os s and
the name of the worksheet so that it does not contain the minus sign it
works great.
I have had used a worksheet named Brazil-008.ord in another set of macros
which happens to have the same statement and it works fine.
Any ideas what could be causing this? Thanks!
|