+ Reply to Thread
Results 1 to 1 of 1

Create List and remove blank Lines

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    Create List and remove blank Lines


    I have a table of users in sheet 1. One of the columns ask for a Yes/No , if Yes then update the 2nd Sheet with some of the details from the table.

    in the attached workbook I was using some code to create a list of only the valid users and so not have blank rows

    the problem is when I copy the code down to row 1000 the entire work book slows down -

    any ideas why or how to speed it up?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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