+ Reply to Thread
Results 1 to 5 of 5

isempty loop

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    51

    isempty loop

    how do I create a loop that doesn't do anything but go down a column a checking there is data in each cell and only stops when there is nothing in the next cell. What I have currently is a code that sorts out data but I would like the code to stop when there is no data in the next cell. I've researched that you can use isempty but I don't really know how to use it.

    thanks alot

  2. #2
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Re: isempty loop

    If you just need to find the last empty row then theres no need for a loop, you can use this instead.

    Please Login or Register  to view this content.
    Please take time to read the forum rules

  3. #3
    Registered User
    Join Date
    07-05-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: isempty loop

    why i need the loop is because I am continuously adding new data so I want a code that stops when the next cell is empty but as I'm new to vba I want to simplfy it so I can understand so I just want a loop that literally checks there is values in column a and when it hits a cell thats empty the code just stops. thats all, thanks guy

  4. #4
    Valued Forum Contributor Steffen Thomsen's Avatar
    Join Date
    10-15-2010
    Location
    Kolding, Denmark
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    953

    Re: isempty loop

    Ok, then use this

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-05-2012
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: isempty loop

    thanks alot steffen thats exactly what I wanted I hope you know how much I appreciate your help absolute life saver

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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