Redimming an array of worksheets if a worksheet doesn't exist to avoid errors

**jimalya** · 08-14-2013, 03:08 PM

I'm creating pivot tables from each sheet in a workbook. Sometimes I may run across a situation when one sheet doesn't exist. I'd like to be able in that instance to just ignore the missing element and move on to the next element in the array without the script continuing and causing an error. I'm very new to arrays and could use any help I could get. Thanks in advance,
Jimalya

Please Login or Register  to view this content.

**Norie** · 08-14-2013, 03:16 PM

This isn't really an array issue, and resizing the array wouldn't help.

You need to check if the sheet exists, if it does then continue on and create the pivot table, otherwise skip that and move on to the next sheet.

Here's one way.

Please Login or Register  to view this content.

**jimalya** · 08-14-2013, 04:16 PM

Thanks alot Norie! That did the trick. It makes sense about the arrays. That's probably why I couldn't find an answer. Thanks.

Redimming an array of worksheets if a worksheet doesn't exist to avoid errors

LinkBack

Thread Tools

Rate This Thread

Display

Redimming an array of worksheets if a worksheet doesn't exist to avoid errors

Re: Redimming an array of worksheets if a worksheet doesn't exist to avoid errors

Re: Redimming an array of worksheets if a worksheet doesn't exist to avoid errors

Thread Information

Users Browsing this Thread

Similar Threads

How to delete a worksheet if it doesn't exist in a list

Worksheet Sort - but all sheets in array do not exist

[SOLVED] Excel Throwing Circular Errors When No Errors Exist

Copy Worksheet to a new Workbook creating if it doesn't exist and add more Worksheets if it does exist

search for worksheet, insert new if doesn't exist

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions