Error: Runtime 1004 - Select method of range class failed

I have 2 sheets in my workbook. Originally I had just 1, but a few days ago added another sheet.

Now when I have the new sheet visible and run this macro I get this run time error.

If I have the original sheet visible, I have no trouble.

What might I need to do to this code to get it to work when the new sheet is visible?

I have a text button with this and other macros assigned to it. If I can get this solved, I'm hoping I can apply the fix to other macros I am sure I will be having similar problems with.

It fails at Range("PreOrder_List").Select

Here is my macro:

Please Login or Register  to view this content.

Thanks.

Cool.

Thanks for the help.

I had previously tried:

Please Login or Register  to view this content.