Last Row issue

[wmtsub]

I am wiorking with a sheet that is foramted as a table. I have tried five separate codes to get the last row in column ag. None work.
Can anyone suggest a solution?

https://www.thespreadsheetguru.com/...to-find-the-last-row-or-last-column-using-vba

 

[igold]

The long way around would be for a Table named "Table1"...

Sub test()
    With ActiveSheet.ListObjects("Table1")
        .ListRows(ActiveSheet.ListObjects("Table1").ListRows.Count).Range.Select
    End With
End Sub

 

[igold]

I did not see that you asked for the last row in column ag. If this is a table, the last row in column ag is the last row in the entire table. If you wanted select the last cell in column ag then you would need to know what the column number is with reference to the table. If column ag was the 9th column of the table then something like this could be used.

ActiveSheet.ListObjects("Table1").DataBodyRange(ActiveSheet.ListObjects("Table1").ListRows.Count, 9).Select

 

[wmtsub]

thank you

 

[igold]

You're welcome.