LastRow_Remove

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

Edit 2024-12-04: Fixing the call to active sheet in WB Workbook

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydevlib.com

Linkedin Login

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

Views 198

Downloads 94

CodeID
DB ID