compariniaa
07-25-2006, 01:39 PM
I'm trying to populate an array with 119 values from a range. The range is in O62:O181. When I do a
for r = 62 to 181
loop, I get a "Subscript out of Range" error
however, when I change it to
For r = 1 to 119
there's no problem. Furthermore, neither of these work if the proper sheet is not selected.
I've included a workbook with dummy data and my affected procedure. Any help is much appreciated
for r = 62 to 181
loop, I get a "Subscript out of Range" error
however, when I change it to
For r = 1 to 119
there's no problem. Furthermore, neither of these work if the proper sheet is not selected.
I've included a workbook with dummy data and my affected procedure. Any help is much appreciated