VBA Find last cell in Column 2 of Word table

Shelley Lou · #1 04-11-2024, 12:38 AM

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?

Italophile · #2 04-11-2024, 04:04 AM

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What formula can I use to find the lowest cell in a column that has a value in it?	EddyWD	Excel	3	04-20-2016 09:29 PM
VBA Word - Find Specific Table - Prepend & Append Data to Each Cell	jc491	Word VBA	3	12-02-2015 09:48 PM
VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color	jc491	Word VBA	8	09-30-2015 06:10 AM
Find text within cell and return column and row title next to the name on a new sheet.	tanyabowring@live.co.uk	Excel Programming	2	03-26-2015 01:48 AM
How do I reference a merged cell in a multi column & row table in MS Word ('03')?	jihanemo	Word Tables	0	03-18-2009 08:33 AM