+ Reply to Thread
Results 1 to 6 of 6

Extra rows in worksheet

  1. #1
    Registered User
    Join Date
    01-31-2014
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    7

    Extra rows in worksheet

    Hi there, I'm using Excel for holding lots of numerical data. Another software program pulls the information from Excel and is used to evaluate the data. The problem I am having is that some of the worksheets in my workbook have extra rows, and by "extra" I mean over 1,000 extra, blank, empty, rows. This means that in the other software program, it pulls over thousands of blank cells that have to be deleted every time it is opened. I've cleared the formatting for the extra rows, and still haven't found a solution.

  2. #2
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,880

    Re: Extra rows in worksheet

    How are you setting the range for the other program to "grab" data from your spreadsheet. Have you defined a range for it to "grab?" Perhaps some more information. Cannot even make a guess with out more information. How do you know this is an excel issue and not an "other software" issue?
    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
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Extra rows in worksheet

    Hi,

    Formatting has nothing to do with it.

    Are these blank rows in the middle of your data or are you saying that blank rows below your last data row are pulled in?

  4. #4
    Forum Contributor
    Join Date
    04-24-2007
    Location
    NYC
    MS-Off Ver
    2k3/2k7/2010
    Posts
    270

    Re: Extra rows in worksheet

    Hightlight sheet, sort by A-Z. It should push all the empty rows to the bottom.

  5. #5
    Registered User
    Join Date
    01-31-2014
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Extra rows in worksheet

    The range is defined by column header in Excel...the number of rows it pulls over is based on the number of "active" (for lack of a better word) cells/rows in Excel...For example, if I have data entered in Columns 1-3, rows 1-10, the other software will pull the information from the exact same range. However, in my problem worksheets, I have data entered as mentioned before, but the other software is pulling data from columns 1-3, rows 1-1456. In my problem worksheet, the vertical scroll bar in Excel automatically shows rows 1-1456, rather than just one full page or what I have data entered through. When coupled with the knowledge I have of how the other links and worksheets work fine, I really believe this has something to do with Excel rather than the other software. It is as if Excel thinks there is something in those cells, but there isn't, at least not that I can find.

  6. #6
    Registered User
    Join Date
    01-31-2014
    Location
    Kansas
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Extra rows in worksheet

    The empty rows appear below the last of my data.

  7. #7
    Administrator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    21,880

    Re: Extra rows in worksheet

    Insert this short VBA in your worksheet and run it.

    What answer do you get when you run it?

    Please Login or Register  to view this content.
    How to install your new code
    1. Copy the Excel VBA code
    2. Select the workbook in which you want to store the Excel VBA code
    3. Press Alt+F11 to open the Visual Basic Editor
    4. Choose Insert > Module
    5. Edit > Paste the macro into the module that appeared
    6. Close the VBEditor
    7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

    To run the Excel VBA code:
    1. Press Alt-F8 to open the macro list
    2. Select a macro in the list
    3. Click the Run button

+ 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. [SOLVED] Extra rows being hidden in loop to hide rows
    By gtol in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-11-2013, 07:33 AM
  2. Replies: 8
    Last Post: 08-27-2012, 04:37 PM
  3. extra page on a worksheet
    By eric102480 in forum Excel General
    Replies: 2
    Last Post: 06-21-2007, 10:38 AM
  4. [SOLVED] Why the extra rows??
    By Robert Brown in forum Excel General
    Replies: 3
    Last Post: 07-28-2006, 10:20 AM
  5. [SOLVED] how do I get rid of extra rows
    By sarahtar in forum Excel General
    Replies: 1
    Last Post: 11-12-2005, 11:35 PM

Tags for this Thread

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