Results 1 to 12 of 12

Thread: [RESOLVED]Looping - if Cell value is blank go to next i

Threaded View

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Jan 2007
    Location
    England
    Posts
    234

    Resolved [RESOLVED]Looping - if Cell value is blank go to next i

    Hi,

    I am looping through a list of items and if a certain cell is blank i am to skip the next couple of steps and go to the next item in the loop
    inside the loop i have attempted this, but it wont compile so obviously there is something wrong
    ranInd is a range, so if this value is blank i want to go to the next range

    cheers
    VB Code:
    1. If ranInd.Cells(9).Value <> "" Then
    2.      Next i    
    3.      End If
    Last edited by Mitch_s_s; Feb 3rd, 2007 at 08:00 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width