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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Range headings 0
Save last item copied 0
Subscript Out of Range 0
Create a chart from a table in word thats dynamic 0
Dumb question alert! What program to use? 0
Dealing with the error: unable to filter on excel hc home school 0

Top