Check if sheet exist based on drop down list

**oerberg** · 03-22-2016, 11:15 AM

In cell D12 I have a drop down list, I have written a macro that allows me to create a new worksheet and taking the name from the selected name in the drop down list.

My issue is that I want to make an error check to see if worksheet has already been created, however I am stuck in the first part, can anyone help me get unstuck?

Please Login or Register  to view this content.

**xladept** · 03-22-2016, 12:14 PM

Hi oerberg,

What is your "SheetExist" code?

**oerberg** · 03-23-2016, 03:06 AM

Hi xladept,
There is no code, this is just a placeholder for what I am missing.

**xladept** · 03-23-2016, 11:55 AM

Something like this?

Please Login or Register  to view this content.

Check if sheet exist based on drop down list

LinkBack

Thread Tools

Rate This Thread

Display

Check if sheet exist based on drop down list

Re: Check if sheet exist based on drop down list

Re: Check if sheet exist based on drop down list

Re: Check if sheet exist based on drop down list

Thread Information

Users Browsing this Thread

Similar Threads

Pivot Table has dates in drop-down list that don't exist

[SOLVED] Check First IF Sheet Is Exist With The Name Of Cell K7 If exist Then run the code

[SOLVED] check column headers against sheet names if sheet not exist create it

Function to check the sheet name exist or not based on sheet values

Check If Folders in a List Exist

macro to check if a value exist in sheet and add it if it doesnt

macro to check if a value exist in sheet and add it +other parts of row if it doesnt

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions