Removes last row in a table starting certain cell.
Creating and using this function was fun, I needed to remove the last row from a table frequently, maybe after adding some rows using another macro.
StartingFromCell variable will be used to count how many rows in that column, and starting from that row, it will remove last row in table.
Removal of row is happen as EntireRow.Delete, you can use ClearContents instead, line is already there and commented, full row will be affected in both cases.
Needs Countcolumncells, GetColumnName



My Own Work

Optional StartingFromCell = "A1", Optional Shee = "Active", Optional WB = "This"

Views 1 Downloads 0