Selecting last row in a table that changes size

[liam91]

Hi guys

I have a program running that places the results from a different program in a single column table, increasing one row at a time when the macro is run. Problem is I need to select the last value entered in the table (bottom row) and past it on itself [to remove the today() value and leave me with the actual date so it doesn't update to today every time the macro is run]. The copy and paste values part I know how to do, just not actually selecting the last row in a column that is changing size.

The code below is the code I'm using to create the column, I'm sure it is a simple addition to the code just not sure where to go?. Excel 2010

Dim Tooth_Table As ListObject
Dim Table_Row As ListRow

Set Tooth_Table = ActiveSheet.ListObjects(1)
Set Table_Row = Tooth_Table.ListRows.Add

Table_Row.Range(1, 1).Value = "=Today()"

Cheers

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)