Code to select range and open a user form is opening the wrong range

I don't see how this can be possible... so I must ask here. My code is

Please Login or Register  to view this content.

Yet it doesn't open the form for this table... it opens the form for another RANGE that is higher on the sheet. I don't understand how this could be. When I record the macro for this, it always opens the correct form, and then when I run it always opens the wrong one.

Hard to say for sure without having a sample of the workbook at hand but at a guess I'd say that all errors have been turned off as you can't have a range name called "Table1[#All]" so the named range isn't being changed from its previous setting.

Your code should not run at all as it is syntactically wrong - it should be:

Please Login or Register  to view this content.

However, there are issues with this method - see MSKB article here. Your data needs to start in A1:B2 or be named Database. This should work:

Please Login or Register  to view this content.

assuming you don't have an existing range named Database.

Glad to help. Please don't forget to mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save