Subscript out of range

All:

I'm new to VBA, however I'm an experienced programmer. I'm running the following routine:

Please Login or Register  to view this content.

The bolded line gives the subscript out of line error. As an additional debug step, I tried declaring another random variable called test2 (variant) and the line test2 = test(i) also returns this error.

This is very puzzling to me, as the LBound and UBound of test (as determined by stepping through the code) are 1 and 66 returned, yet this is crashing out on the first iteration of the loop when i=1!!!

Does anyone have any insight in to this whatsoever?! I have burned a whole day on this with no progress, and I would really appreciate any help.

Thanks in advance, mcukier

Please take a few minutes to read the forum rules, and then edit your post to add code tags.

Assuming LBound is zero, what cell are you storing data in, in the first iteration of the loop?

Yeah, it looks to me like you're trying to access row zero (doesn't exist).

Try the following instead:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

Hey Guys:

Thanks for the responses. On the first iteration of the loop, i is 1 because LBound is 1. I have verified this with variable watch, and mouseover. As an additional debug step, I verified that I get the same error with the bolded line below inserted within the for loop rather than the line that referenced the cells:

Please Login or Register  to view this content.

I still get the same error, which is clearly indicating that the test(i) reference is generating the error. (also, during debug I can simply mouseover that part of the statement, and the tooltip says test(i) = subscript out of range, or something along those lines)

And, if I link to this DDE object through the GUI, it works and does in fact populate all 66 rows with the appropriate formula (I paste the DDE formula in the first row, then highlight 66 rows in that column, hit F2, then ctrl + shift + enter, and all the DDE forumulas appear as expected). However, for my application, that method won't work as I need to be able to change the DDE request based on the information in a given cell....

Like I said... I'm absolutely baffled!!

SIDENOTE: the application I'm working with does NOT have a well defined (or printed out) DDE protocol... so I have no way of actually knowing what data is being returned to me. It seems to me that it's a 1x66 array of numbers.... judging from my experience within the excel GUI. Not sure if this is relevant or not.

Thanks, mcukier

Look at test in the Watch window -- is it two-dimensional?

You're welcome. Would you please mark the thread as Solved?