Trying to determine if worksheet exists, subscript out of range error

Hello,

Here is what I need help with:

The app I'm working on is used quarterly. For this procedure I want to check the current file and see if the worksheet 'Proposed' exists. If it does exist, then I want to delete it. If it doesn't exist, I want to add it. Eventually (not in this sub) I want to open up another excel file that the user has designated and then copy the values from that file into the worksheet that I have created.

For some reason or another, the below code is choking. I keep getting a Run-Time Error '9': Subscript out of range. It chokes on the first line Set WsA = Sheets("Proposed").

Any help would be greatly appreciated.

-js999

Please Login or Register  to view this content.

Boy ... too much coffee this morning ...
Here is the solution ... apologies for wasting the server space.

-js999

Please Login or Register  to view this content.