VBA Run-Time Error '9' Subscript out of range

Grab the Free VBA Quick Reference Guide
In this Excel VBA (Macro) Tutorial we review the rutime error 9.

This error is caused when the index of an array and members of collections is outsie their defined range

[adlan]

Man, I have to thank you for this! Completely did not solve the problem I was looking for, but it saved another :)

[FPrimeHD]

Lol, I am building my first database using this just to familiarize myself with VBA prior to entering the work force (math major) and when balancing homework and trouble shooting this, I find myself staring hopelessly into space after 2 minutes of working on this :D

[RajeshwarUma]

I write my sheet name correctly but offer opening the existing Excel not responding pls help me same error

[kalaianbu]

In VBA project window, microsoft exel object and sheet names are not visible. Can't able to run macros. Any solutions

[nareshsharma]

Hi Sir, I need your help.
we have a uqique number in a cell. for example 1032. I have used formula for found out the mid of 2 number. result is 03. now I want to the same number is showing like 3rd, 2nd, 1st, 4th as per the unique no

[siguerhakim]

Thanks sir for your explanation about time error '9'

[johnheath]

I am getting the subscript our of range with this code -
Dim Sym As Range
Set Sym = Range("B:B").Find(What:=Range("A1").Value, LookIn:=x1Values, LookAt:=x1Whole)

I want to find the value stored in A1 and look for it in column B.

Thanks

John

[marcw.]

This error does not happen when I run macro in 2007 - but does in 2021. Im changing focus to different workbook or sheet - and they do exist !

[safesanju]

I have 5 row first Colum have same 5 name “sanjay, second column have same 5, date 27-07-2020 and third column have 5 value, 100,200,300,400,500 …I want to merge duplicate name and sume of 5 value in and merge same date….i want whole data in one row….please help me …excel VBA code for it.