Problem with - sign in sheet name??

[Bub]

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!

 

[joel]

A sheet name cannot contain a minus sign. I suspect in the othe
workbook the minus sign was not part of a string name but wa
interpreted as a real minus sign and you were perfrom a subtraction.

for example

A = 5
B = 3

A - B = 2

Which is not the same as the string

"A - B"

You code has double quotes around the variable s="Brazil-008.ord" whic
makes it a string.