Incrementing through Rows and Columns

**zwieback89** · 10-13-2011, 05:26 PM

Hello,

I am trying to increment through columns within a set of rows. My sequence is:

1. Increment through Rows of the range
2. Within each row, increment through the column of the selected row and grab the value of each column till the last column.

I am stuck in incrementing through the column without hardcoding of the column number.

Here is what I have so far:

I know my start row, end row, start column which is always 1, and end column. Is there a way to avoid typing icol+1, iCol+2, iCol+3 so on and so forth and incrementing till it hits the last column which is captured by the variable varLastColumn,

Please Login or Register  to view this content.

Your feedback is appreciated.

Thanks.

**Richard Buttrey** · 10-13-2011, 05:33 PM

Hi,

Why are you adding +1 to your iCol loop counter which is automatically increasing by 1?

**zwieback89** · 10-13-2011, 06:13 PM

My iCol loop will not loop till the next number because each cell is in a different row,column combination. Maybe if you see a screenshot of the data, it will make better sense.

**Richard Buttrey** · 10-13-2011, 06:42 PM

Sorry I don't understand what you mean. The picture of the code you posted is not in agreement with the code in your original post which just adds to my confusion.

Rgds

**Leith Ross** · 10-13-2011, 06:45 PM

Hello zwieback89,

Perhaps something like this code would work for you.

Please Login or Register  to view this content.

**zwieback89** · 10-13-2011, 06:50 PM

Hi,

Based on your clarification that the iCol loop would automatically increment, I removed the col+1, col+2, col+3 so on and so forth from each of the variables to see how the col increment from 1 to the varLastColumn variable. When I ran the script, the iCol was showing 1 and not incrementing from each variable to the next.

If you see the data set, the goal is to take this data and rearrange it into another format into another tab. The purpose of putting each row and column combination into a variable is so that I can capture the value in this variable and add into the required position in the other tab. In the data set, I loop through each row. Within each row, I want to loop through each column, grab the data from each column till I hit the last column. Then I move to the next row. I then loop through each column in the next row and grab each value into the cell and insert into the destination.

Thanks.

**Richard Buttrey** · 10-13-2011, 07:45 PM

You say, "if you see the data set..", but of course we didn't and hence we couldn't possibly know what your goal was.

Are you still saying that having now removed the '+1' from the code that you are nevertheless still having problems?

Regards

**zwieback89** · 10-13-2011, 07:57 PM

The attachment "table.gif" shows how the data set appears in the source data.

Yes, I am still struggling...I will try to work on this and see if I can get it.