I'm having some problems when I try to handle an array from a range. Here's the code:



This gives me a subscript out of range error. However, if I just use msgbox, it works fine.

kruuth,

Your For counter is going too high, since your array starts at Row 2.

Let's say your variable "lr" is 5. Then the array is built from A2:A5, which is 4 values.

Next, your counter is going from 1 to 5 to read from the array. When the loop hits 5, it goes beyond the range of your array.

Your loop counter needs to go to "lr-1" if the start of the range is hard-coded to be 2, as your example shows.

You haven't defined "lr" anywhere, let alone assigned a value to it, but I'm assuming it's a Long Integer datatype.

It's worth mentioning that you're loading cell data into a Variant array, and then loading that Variant data into a String variable without any sort of conversion. Also, your String variable's name implies that it is holding some sort of Date, which raises the next question; is it a Date? Or a String? Or something else?

By the way, rather than looping, like you posted, you could just use this to end up with the same value in temp_date:
temp_date = str_DATE_Ary(lr-1, 1)

Hope this helps,

Dennis

There are only (lr-1) items in the array.

eg if lr is 21 then there are 20 items in the array

D'oh. It's the range <facepalm>

Actually I have LR defined I just left it out.

You could avoid this problem by using LBound and UBound.