Error "9"

[TylrA]

I'm making a spreadsheet that organizes several weather conditions and made an array that lists the conditions, but I get an error when I move to the 13th form (not a prank, it just happens on 13).

Dim sn() As Variant
sn = Array("Wind Speed", "Wind Direction", "Ambient T", "Wind Chill Temp", "Dew Pt Temp", "Barometric Pressure", "Backpanel Temp", "POA Irradiance", "GH Irradiance", "Relative Humidity", "Precipitation", "Precip Intensity", "Direct Normal Irr", "Diffuse Irr")
Worksheets(sn(13)).Activate

The debugger gives me error 9 and highlights the third line.

Is there a limit to how many terms you can put in an array or what is going on here?

NOTE: I ENCOUNTERED NO PROBLEMS RECALLING sn(0) TO sn(12). Ex. "Worksheets(sn(10)).Activate" was just fine.

 

[mrmmickle1]

Do you have a trailing or leading space on your worksheet name?

The code works fine for me...

 

[TylrA]

I'm so sorry. It looks like my problem was actually a typo. The name in the array didn't match the name of the worksheet, so it couldn't find it.

 

[mrmmickle1]

No worries. Glad you were able to solve your problem.