When iterating through cells in a table column, how do I get the cell's row number within that table?

  • Seems like this should be a simple thing, and maybe it is, but I can't seem to find out how to do this. I want to keep track of which rows within the table certain cells are but I can't find a way to get the table row number rather than the worksheet row number.

  • Ok, well let's assume your table is called "MyTable" and exists in "Sheet1":