Spreadsheet - Method 'Range' of object '_global' failed

Hello. I'm new to this forum but after browsing it for a bit I feel confident that some of you probably will be able to help me with my problem.

I play the known MMO World of Warcraft and I use spreadsheets to try and maximize my performance. However I am having trouble with a specific spreadsheet. If you want to take a look at it to be able to picture it in your mind you can get the spreadsheet here.

The problem:
When pressing a button which should handle some data I get a runtime error 1004 "Method 'Range' of object '_global' failed".
I get this error when pressing 3 different buttons in the spreadsheet. The debug code is the same for 2 of the errors and I will list the debug below

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I have talked to the person maintaining the spreadsheet now but all she could tell me was to use Excel 2003 instead of 2007. I then tried using Excel 2003 but still got the error. Then I tried installing Office 2003 in a fresh copy of windows xp pro in a virtual machine to rule out anything I might have messed up myself but still got the error.

I would really like some help regarding this matter as I have no clue why I keep getting this error. Any help is appreciated.

Thank you.

hi,

For some reason I can't access the file, are you able to attach it to this thread in Excel 2003 format?
This error may suggest that the named ranges don't exist. Can you see either of them listed under Insert - Names - Define?

Please Login or Register  to view this content.

Is the sheet protected?
Does the below work?

Please Login or Register  to view this content.

btw, from my experience & a quick test (but only on the Activesheet) you don't need to use the syntax

Please Login or Register  to view this content.

but... I do stand to be corrected!

hth
Rob

Thank you for replying

1. I have attached the spreadsheet to this post.
2. Yes I can see the range names and I know other people using Excel 2003 can use this spreadsheet without problems.
3. I don't think the spreadsheet is protected but how can I verify this?
4. How do I execute

Please Login or Register  to view this content.

to check if it works?

I'm a noob to Excel still so thanks for your patience with me

Edit:

Originally Posted by broro183

hi,

Does the below work?

Please Login or Register  to view this content.

btw, from my experience & a quick test (but only on the Activesheet) you don't need to use the syntax

Please Login or Register  to view this content.

but... I do stand to be corrected!

hth
Rob

You sir, are a genious! I removed every (Names) part I could find in the debug code and now it works.
Thank you very much :D

Thanks for the feedback - I'm pleased I could help
If you're happy with the solution please mark the thread as solved.

re # 4:
To test (some) lines of code you can resize the VBE to let you see the Excel window as well, press [ctrl + G] in the VBE to bring up the immediate pane, type the the line of code to test & then press [enter].

edit: Ooopps!
I missed #3:
To check if a sheet is protected, activate the sheet in Excel & then look at Tools - Protection and it will either have the option of "Protect sheet" or "unprotect sheet".

hth
Rob