Subscript out of Range Error with using Worksheets.Select on an existing Worksheet

Hello,

in my workbook, I have a hidden worksheet, in which I set some ranges to appear in a diagram. I make the sheet visible, select the worksheet, set the ranges, and put them as a series in my diagram.
But when I look at the error variable (which I did to find out that I need to make the sheet visible), I get an "subscript out of range" error. The sheet is existing (otherwise I couldn't make it visible), I can set the ranges, and my code works, but I want to know what's wrong here. Thanks in advance!

Here a snippet of my code:

Please Login or Register  to view this content.

I will try the second option, and see if that works. Nicer than mine anyway (which was working in earlier versions with Worksheets.Select, but clean code is preferable).

But any idea, why Excel first sets the worksheet visible, so is finding my worksheet, and than seems to lose contact, to find afterwards the right data on the selected worksheet? Do I activate the sheet while making it visible?

I've tried with a blank excel workbook, as I cannot post the original file, and just have put the code, where I set visibility of the worksheet "Coordinates", and afterwards select it.

Making the worksheet visible leaves the internal error set to 0 (so no error), selecting it afterwards results in error 9 (subscript out of range). I can override that with "On Error Resume Next", I know that I get the right data in my original sheet, I can do nicer programming avoiding the Select-Method - but I want to understand, why Excel-VBA is throwing there an error.