View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Bub@Mailinator.com is offline
external usenet poster
 
Posts: 1
Default 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!