200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
I am attempting to search a workbook filled with data utilizing the "fast search" VBA code. I have changed the necessary items relative to my workbook and am receiving a run time error (imagine that?) #9 at line
'Check if the value in the row equals our search value
If (dataArray(i, searchField) = searchValue) Then
If any of this makes sense I would appreciate a shout back.
thanks, If (dataArray(i, searchField) = searchValue) Then
Rob
Error #9 means "Subscript out of range", and in this case it means that the coordinates i and searchField do not correctly define an element of the array dataArray.
To begin, both i and searchField must be integers, not necessarily of Integer type but without decimals. They must both be positive. They must be >= LBound(dataArray) and <= UBound(dataArray) for i and >= LBound(dataArray, 2) and <= UBound(dataArray, 2) for searchField respectively.
If this array contains values taken from a worksheet range, bear in mind that i defines the row and searchField the column.
Another good way is to look at the Locals window immediately after the crash. There you will find all values of dataArray listed with their coordinates.
