what does 'Subscript Out of range' mean??

R

Ron de Bruin

Hi Gary

For example if the sheet not exist you will see this error

Sheets("dfdsf").Select
 
J

JLatham

Ron has given one example of when you would see that error. There are other
conditions that will generate it. Generally speaking, if you attempt to
reference a member of a collection or an array that does not exist, you will
get that error.

Another example:
Dim anyArray(1 To 100) As String
Dim myElement As String

myElement = anyArray(101) ' will generate the same error.
 
Top