Error "9"

TylrA

New Member
Joined
Aug 3, 2015
Messages
5
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).

Code:
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.
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

mrmmickle1

Well-known Member
Joined
May 11, 2012
Messages
2,456
Do you have a trailing or leading space on your worksheet name?

The code works fine for me...
 

TylrA

New Member
Joined
Aug 3, 2015
Messages
5
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,678
Messages
5,524,241
Members
409,566
Latest member
MickB

This Week's Hot Topics

Top