I have a list that is always changing in length. The list template, which includes formatting and formulas, is always longer than the list will ever be, so when the list is inputted, I would like to delete the empty rows of the list from the bottom up. But I can not delete the entire row. For example, I have the range ("B3:F25") and column "B" has the list of items. If the list only goes to "B13" I would like the formatting and formulas from "B14:F25" to delete, or to become default.
Here is an example:
Deleting Extra Rows.xlsm
Bookmarks