+ Reply to Thread
Results 1 to 6 of 6

continuing and starting new with

  1. #1
    Registered User
    Join Date
    01-29-2014
    Location
    Regina, SK
    MS-Off Ver
    Excel 2013
    Posts
    20

    continuing and starting new with

    Sample of my code:

    Please Login or Register  to view this content.
    So the problem is that "If rFound Is Nothing Then End With" doesn't work. Am wondering can I say "Next with" or "GO TO Next With". What would be the right thing here.

    Last edited by xcel_rider; 04-09-2014 at 10:53 AM.

  2. #2
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    330

    Re: continuing and starting new with

    Please Login or Register  to view this content.
    Last edited by Leon V (AW); 04-08-2014 at 11:35 AM.
    Sub Reputation()
    Dim Problem as Variant
    Dim Reputation as Integer
    For Each Problem in Forum.Threads
        If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1
    Next Problem
    End Sub

  3. #3
    Registered User
    Join Date
    01-29-2014
    Location
    Regina, SK
    MS-Off Ver
    Excel 2013
    Posts
    20

    Re: continuing and starting new with

    ok

    Please Login or Register  to view this content.
    that?
    Last edited by xcel_rider; 04-08-2014 at 11:35 AM.

  4. #4
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    330

    Re: continuing and starting new with

    Quote Originally Posted by tcmcgonigal View Post
    Wait.

    Please Login or Register  to view this content.
    Doesn't work
    sorry it is a goto statement. My fault I am so used to calling it exit with I didn't think. Edited answer

  5. #5
    Registered User
    Join Date
    01-29-2014
    Location
    Regina, SK
    MS-Off Ver
    Excel 2013
    Posts
    20

    Re: continuing and starting new with

    Quote Originally Posted by Leon V (AW) View Post
    sorry it is a goto statement. My fault I am so used to calling it exit with I didn't think. Edited answer
    I edited my reply, can you review the new code

  6. #6
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    330

    Re: continuing and starting new with

    the ExitWith needs a collon ":" that is how a goto statement knows where to go
    so
    Please Login or Register  to view this content.
    if you are using multiple withs in a single macro you will need seperate goto markers

+ 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. Looping for filtering through data to rmove stock based on if statements
    By chrisjames25 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-04-2013, 01:11 PM
  2. Looping with IF statements and malfunction?
    By c0d3crunch3r in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2012, 04:02 PM
  3. Replies: 5
    Last Post: 09-27-2012, 07:30 PM
  4. Doublecheck with second lookup starting starting after first match
    By zekethewolf in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2011, 06:36 AM
  5. Looping IF statements?
    By Leumas786 in forum Excel General
    Replies: 1
    Last Post: 06-30-2011, 03:12 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