Select Sheets based on variable array -ERROR 9 Subscript out of range

**airmiles** · 09-18-2012, 09:17 PM

Hi, I've tried a few forums and can't quite understand why I'm getting an error with the following code:

I'm attempting to select certain charts, based on a list of names entered between rows 9 and 35 on a worksheet (in this case 1,2,4,7,11,12 have been selected. If I use the actual names of the sheets as in the unused line of code, it works fine. Is there an easy way to fix this, I wonder?

Please Login or Register  to view this content.

**Andy Pope** · 09-19-2012, 05:13 AM

Please Login or Register  to view this content.

**airmiles** · 09-19-2012, 07:06 AM

Thanks Andy, but I still get the same error message on the charts(split(... line of code. Any ideas

**Andy Pope** · 09-19-2012, 07:21 AM

it worked for me on a test file.

can you post example workbook to illustrate the problem

**airmiles** · 09-19-2012, 07:28 PM

Thanks again Andy, while sanitising my rather large spreadsheet to send through, the code suddenly worked. Found that I had referenced one of the charts on my list incorrectly. Now resolved