+ Reply to Thread
Results 1 to 2 of 2

Cannot get blank row in list

  1. #1
    Registered User
    Join Date
    09-04-2013
    Location
    Southport, England
    MS-Off Ver
    Excel 2011(for mac)
    Posts
    28

    Cannot get blank row in list

    In the attached file the macro produces an ordered list on Field2 sheet from the list, in no particular order and can be of any length, on the Field sheet, determined by the listings of the columns L & J on the Set Up sheet.

    The problem I have is when the last part of the Field sheet is used, in this case rows 430 to 433 I cannot get a blank row on the Field2 sheet, in this case row 402, before continuing with the rest of the listing.

    As can be seen there are a number of other lists on the Set Up sheet that I am using as part of an overall project, but am concentrating on this first. I then intend to incorporate answers to this problem into the rest.

    If anyone would be willing to help me with this I can incorporate these sections into another file to post. The end result is that I produce a pdf file consisting of listings of two columns for Track events followed by Field events. The Track events have involved a bit more sorting. What I would like to do is get it all working and then ask for advice on how to improve on the way I have done it.

    Many thanks in anticipation
    Attached Files Attached Files
    Last edited by DPJW; 01-04-2018 at 08:46 AM.

  2. #2
    Registered User
    Join Date
    09-04-2013
    Location
    Southport, England
    MS-Off Ver
    Excel 2011(for mac)
    Posts
    28

    Re: Cannot get blank row in list

    I have gone back to using ranges instead of arrays and that is working so I'll close this.
    Thank to those have viewed this.

+ 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] When A Blank Cell Isn't Blank And The List Function
    By Billy Corman in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 12-03-2015, 12:50 PM
  2. VBA: Copy non-blank and paste to separate sheet ONLY blank cells (running list)
    By brolsen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2014, 03:34 PM
  3. [SOLVED] autofill vertical list horizontally with 2 blank cells in-between each list item
    By Phily915 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-14-2014, 08:15 PM
  4. Convert Matrix to List (excluding blank cells from list)
    By cameron.rumball in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-02-2013, 12:35 AM
  5. [SOLVED] Excel 2010--Blank List Wanted in Drop Down List
    By AgeOfEgos in forum Excel General
    Replies: 4
    Last Post: 08-15-2012, 03:13 AM
  6. Replies: 4
    Last Post: 02-20-2012, 02:24 PM
  7. Skipping blank cells in a list to create an uninterrupted list
    By bdance in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-02-2007, 06:26 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