Need to check if worksheet exists and execute code

**chiidzzz** · 09-23-2012, 09:25 AM

Hey all,
Need help with my workbook.
In the summary sheet, columns A and B are players names, which are retrived from a list
I have several worksheets named after some players names,
when I enter in column A the name "John" and in column B the name "Joe" for example, and i fill the row with information, and I type BAB in the L column, this code automatically copies the data to worksheet named "John" and to worksheet named "Joe" and makes some adjustments.
The problem is I need help to bypass the error generated when I enter a name in column A or B that does not have a worksheet named after it.
I need to edit the code to be able to check wether the worksheet of the player exists, if true then continue the code, if not then display a message box saying that the worksheet "player name" does not exist.
Thanks

Please Login or Register  to view this content.

**blobbles** · 09-23-2012, 10:15 AM

Your code should look like this (and use the Code tag next time you paste code!):

Please Login or Register  to view this content.

**Cutter** · 09-23-2012, 10:36 AM

@ chiidzzz

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at the top of the page and read Rule #3.
Thanks.

**chiidzzz** · 09-23-2012, 01:48 PM

Thank you blobbles, but your code is returning an error, I think the problem is with this part:

Please Login or Register  to view this content.

**blobbles** · 09-23-2012, 09:44 PM

Sorry, try this:

Please Login or Register  to view this content.

**chiidzzz** · 09-24-2012, 07:22 AM

still getting error 9 subscript out of range

**blobbles** · 09-25-2012, 08:49 AM

Which line of code is highlighted when you click "Debug" when you see this error message? I just tested the code I wrote and it looks fine...

**chiidzzz** · 09-25-2012, 12:00 PM

this one

Please Login or Register  to view this content.

**blobbles** · 09-25-2012, 08:53 PM

OK, the problem with your code is that you can't have an "a" when you use the ....Cells(Rows.Count, "a")... you need to use a number instead. So it should read:

Please Login or Register  to view this content.

**blobbles** · 09-25-2012, 08:55 PM

That's a tip, you can only use .... Range("A" & RowNumber)... when referencing a column using the "A,B,C" etc notation. When using the Cells syntax you need to use row numbers and column numbers, something like ....Cells(1,3)...

Need to check if worksheet exists and execute code

LinkBack

Thread Tools

Rate This Thread

Display

Need to check if worksheet exists and execute code

Re: Need to check if worksheet exists and execute code

Re: Need to check if worksheet exists and execute code

Re: Need to check if worksheet exists and execute code

Re: Need to check if worksheet exists and execute code

Re: Need to check if worksheet exists and execute code

Re: Need to check if worksheet exists and execute code

Re: Need to check if worksheet exists and execute code

Re: Need to check if worksheet exists and execute code

Re: Need to check if worksheet exists and execute code

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions