Filling Table From Array Results in Subscript out of Range Error

Hello. My code below to fill a table (ChartTable1) with the contents of an array works flawlessly so long as there is more than one row of data being moved into the table. However, if the array only contains one row of data, then I receive a subscript out of range error when attempting to fill the table with the array contents.

The last line of code results in the error only when the array tries to fill the table with one row of data. Specifically, hovering over the error reveals UBound(v, 2) = subscript out of range.


As the array may contain both single or multiple rows of data, I need to revise the last line of code to handle both conditions without error. Any help is much appreciated!


Thanks!

Please Login or Register  to view this content.

While I do have headers, the problem occurs with one or fewer rows of actual data. The IF condition idea makes sense to try. But I'm at a loss for how the UBound portions should be adjusted to handle the case of 0-1 rows of data.

Another possibility

Please Login or Register  to view this content.

Originally Posted by cubangt

@matt w here is what i was trying to describe in my post, looks like this would do the trick.

I tried this line of code, but it functions identical to the original code with subscript out of range error for UBound(v, 2).

Originally Posted by Fluff13

Another possibility

Please Login or Register  to view this content.

Thank you, Fluff13. I added "If n = m Then n = m + 1" line as you suggested and it functions as expected now. I'm not exactly clear how this works, but it does.

Originally Posted by sintek

Your original code will also error if your table does not start in row 1...

Thanks for that insight. Is that the header row that must start in row 1....or is it the data row that must be in row 1?