cellsfinalrow

Good afternoon all, I have a macro enabled workbook running in Excel 2016. On one tab I've set up a button that runs a macro that will add a new row to a table and set some values in it. Here's the code. Sub ServiceHealth_Tbl() Dim lo As ListObject Dim FinalRow As Long Dim myValue As...

I cannot get this code to run except for my active sheet. I will not sequence to the next sheets in the workbook. Any help would be greatly appreciated. finalcol = Cells(1, Columns.Count).End(xlToLeft).Column finalrow = Cells(Rows.Count, 1).End(xlUp).Row For Each ws In ThisWorkbook.Worksheets...