Check if sheet from list exists in workbook

**arlu1201** · 10-25-2011, 01:50 PM

Hi All,

I have a list as follows -
1100
1201
1301
1302
1401
1402
1601

I have worksheets in my workbook as -
1100
1201

I need to check if the worksheet from the list exists in the workbook, if not, create it and rename it as per the list.

I researched a lot online and on this forum but was not able to get the exact code.

Appreciate your help !!!

**davegugg** · 10-25-2011, 01:59 PM

Please Login or Register  to view this content.

Assumes your list starts in cell A1.

**arlu1201** · 10-25-2011, 02:05 PM

Thanks for the code Dave. I had tried one on similar lines and i got the same error - Cannot rename sheet as the same name as another sheet....etc.

The line that gives the error is

Please Login or Register  to view this content.

**davegugg** · 10-25-2011, 02:13 PM

I'm sorry, there were a couple bugs in there.

Please Login or Register  to view this content.

Even though the strings are technically different, a workbook seems to not be able to have a sheet1 and Sheet1 sheet at the same time.
Also, have to make sure we're not comparing a string against a number.