Not recalling variable value

Question

I typically consider myself a super-user for excel-vba related things. However, this one has me stumped.

I have a line of code returning 'runtime-9, subscript out of range', but it appears that the subscript is not out of range.

When the following code is evaluated, it returns the subscript error.

Range(Cells(RowArray(j, 0), coLs(colSetNum, i)), Cells(RowArray(j, 1), coLs(colSetNum, i))).Select

Where RowArray(j,0)=2, colSetNum=0, i=0, and RowArray(j,1)=6. (all values from the mouse-over text).

I checked the locals window, and coLs(0)(0)=2, so it shouldn't be returning this error.

Any suggestions?

so is coLs an array of arrays or is it a two dimensional array, you show it both ways. Maybe you should use coLs(colSetNum)(i) — Scott Craner
– Scott Craner, Commented May 29, 2018 at 15:14
coLs is an array of arrays. Do I have to reference that as (0)(0) rather than (0,0)? — daniel brandstetter
– daniel brandstetter, Commented May 29, 2018 at 15:26
Yes, and also one should avoid using .Select. It slows down the code. — Scott Craner
– Scott Craner, Commented May 29, 2018 at 15:27
Ah, that did it! my next line is selection.copy. I tried just doing Range().copy, but it didn't seem to like that. What alternatives are there? — daniel brandstetter
– daniel brandstetter, Commented May 29, 2018 at 15:35
there are many. it also depends on how you are pasting the copy. But that is a new question. — Scott Craner
– Scott Craner, Commented May 29, 2018 at 15:39

daniel brandstetter · Accepted Answer · 2018-05-29 16:33:23Z

1

Arrays of Arrays have to be referenced as arr(x)(y), rather than arr(x,y).

Fixing this fixed the program.

answered May 29, 2018 at 16:33

16011 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1