Cell Iterator Not Iterating all Columns...

Topics: Developer Forum, User Forum
Jul 10, 2014 at 1:35 PM
I have an Excel 97-04 workbook with one sheet in it. The sheet has 29 columns in it with a header row followed by X number of data rows. When I iterate the header row I get all 29 columns. When I iterate through the data rows I only get 26 columns it stops at column "Z". If I insert columns before "Z" they will be iterated any columns after "Z" will not. If I cut column "Z" and insert it as the last column all columns will be iterated.

Is there something in the spreadsheet could be causing the cell iterator to stop at this particular column? I see no obvious difference between the column settings.
Marked as answer by MarkGoolie on 7/10/2014 at 7:12 AM
Jul 10, 2014 at 2:12 PM
Solved... I rewrote my iterator loop to preload all of the values in an array rather than do some processing as I'm iterating the columns.
Marked as answer by MarkGoolie on 7/10/2014 at 7:12 AM