+ Reply to Thread
Results 1 to 3 of 3

Wait until cell is not blank

  1. #1
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Wait until cell is not blank

    I have the loop below that is looping until a cells value doesnt equal blank. Sometimes the cell value will be empty but have blanks it pulls back, so almost like several spaces and the loop below is reading that as not blank and letting the vba proceed. Is there a way to have it loop until the first cell value is a letter or number or a way to fix this?


    Please Login or Register  to view this content.

  2. #2
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Wait until cell is not blank

    Try this....


    Please Login or Register  to view this content.
    Don't forget to click *

  3. #3
    Forum Contributor
    Join Date
    08-07-2013
    Location
    mo
    MS-Off Ver
    Excel 2010
    Posts
    453

    Re: Wait until cell is not blank

    Works, thanks

+ 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. Replies: 3
    Last Post: 01-23-2014, 12:19 PM
  2. [SOLVED] How to make vba to wait until I select another cell
    By tamilvendhan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-01-2013, 06:08 AM
  3. loop to stop and wait for cell value change.
    By ajwhipple in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-03-2007, 01:04 PM
  4. Wait with calculation of other sheet references after edit a cell?
    By Maria J-son in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-29-2006, 03:30 AM
  5. Replies: 1
    Last Post: 01-11-2006, 09:40 AM

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