Quote:
Originally Posted by Shelley Lou
Hi, apologises but don't think I understand - does this line of code find only the very last cell in Column 2 - I only need to change the very last semi-colon not all of them?
|
Your code loops through the rows in the table. Unless there are vertically merged cells the last cell in a column will be in the last row of the table.
As you are using
i as the row number the statement
Code:
If i = .Rows.Count Then
indicates that you are in the last row and that rCell is, therefore, the last cell in column 2.