Runtime error '9'. Subscripts out of range - Dynamic array

**akabraha** · 08-23-2007, 10:54 AM

Hello,

I have defined a dynamic array called Steps(). I am trying to store the value of a cell in it. But I am getting the error: Runtime error '9'. Subscripts out of range. Not sure what's wrong?

Please Login or Register  to view this content.

Thanks in Advance.. Anil

**akabraha** · 08-23-2007, 11:14 AM

Thanks for looking into it - I figured it out. Had to redim with preserve..

Please Login or Register  to view this content.

Thanks, Anil

**mudraker** · 08-23-2007, 05:38 PM

You could also use

Please Login or Register  to view this content.

Note:- the array starts at 1

Here are 2 others ways to fill an array from a sheet without looping through the cells

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Runtime error '9'. Subscripts out of range - Dynamic array

LinkBack

Thread Tools

Rate This Thread

Display

Runtime error '9'. Subscripts out of range - Dynamic array

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions