+ Reply to Thread
Results 1 to 4 of 4

Skip this Macro Goto another - code required

  1. #1
    Forum Contributor
    Join Date
    08-28-2012
    Location
    nz
    MS-Off Ver
    Excel 2010
    Posts
    125

    Red face Skip this Macro Goto another - code required

    Hi ya

    If a condition is met i need to "GoTo" another Macro, say Macro101 instead of "Sub Blah" even running at all.

    So could someone complete the missing bit, that's it

    Cheers guys




    Sub Blah ()

    If Worksheets("race").Range("X3").Value < Worksheets("race").Range("F49").Value Then (Goto)? Macro101

    Blah
    Blah

    End Sub

  2. #2
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Skip this Macro Goto another - code required

    Hi,
    1)
    Please Login or Register  to view this content.
    2)
    Please Login or Register  to view this content.
    ModuleName = name of the module the Macro101 is in...

    Hope it helps
    Regards
    Miroslav R.

    (If You like my solutions, feel free to add reputation.)

  3. #3
    Forum Contributor
    Join Date
    08-28-2012
    Location
    nz
    MS-Off Ver
    Excel 2010
    Posts
    125

    Re: Skip this Macro Goto another - code required

    Hi Miroslav

    Ok cool

    I should so take a basic night class


    Cheers Dude Added Rep to u

  4. #4
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Skip this Macro Goto another - code required

    You are welcome!
    Thanks for rep.

+ 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. skip blanks on GOTO option
    By Shadmani in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-10-2009, 07:29 AM
  2. macro code required
    By blackpoolbloke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2008, 08:00 AM
  3. [SOLVED] Macro Code required..........?
    By Thyagaraj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-30-2006, 06:10 PM
  4. [SOLVED] On Error GoTo skip needs help
    By dan in forum Excel General
    Replies: 2
    Last Post: 04-24-2006, 01:35 PM
  5. [SOLVED] How to have a Macro skip code if PivotTable/PivotField is not there
    By mholland88@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-29-2006, 07: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