+ Reply to Thread
Results 1 to 3 of 3

Need help deleting empty rows from a range from the bottom of the list up

  1. #1
    Forum Contributor
    Join Date
    09-09-2013
    Location
    California, USA
    MS-Off Ver
    MS 365 Subscription
    Posts
    130

    Need help deleting empty rows from a range from the bottom of the list up

    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

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Need help deleting empty rows from a range from the bottom of the list up

    Try this:

    Please Login or Register  to view this content.
    If your template is longer than 100 rows then change the bottom part of the range
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Valued Forum Contributor
    Join Date
    09-01-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    324

    Re: Need help deleting empty rows from a range from the bottom of the list up

    Please Login or Register  to view this content.


    Shelton A.
    If Helpful, Add Reputaion!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Deleting empty rows if specific cell in row is empty
    By csynic in forum Excel General
    Replies: 0
    Last Post: 07-06-2011, 01:43 AM
  2. Moving duplicates to first empty row (i.e. bottom of list).
    By Folshot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2011, 09:13 AM
  3. Autofilter/delete empty rows is deleting non-empty rows!
    By oOarthurOo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2010, 12:31 PM
  4. unwanted empty rows at worksheet bottom
    By Joe Miller in forum Excel General
    Replies: 1
    Last Post: 08-13-2006, 02:50 PM
  5. [SOLVED] empty rows at bottom of worksheet
    By michael g in forum Excel General
    Replies: 2
    Last Post: 01-18-2005, 06:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1