+ Reply to Thread
Results 1 to 3 of 3

Issue with Select Case and for loop

  1. #1
    Forum Contributor
    Join Date
    05-30-2013
    Location
    Isreal
    MS-Off Ver
    Excel 2010
    Posts
    191

    Issue with Select Case and for loop

    Hello.

    I am using a select case in the middle of my module.

    However once in put the select case into my module for some reason.
    My for loop gets an error.
    I think it's because my select case is written in the wrong syntax.

    This is the syntax I am using:
    Please Login or Register  to view this content.
    What am I doing wrong ?
    Thank you in advance for your help.

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Issue with Select Case and for loop

    Delete the red line.

    Please Login or Register  to view this content.

    It should look like this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Forum Contributor
    Join Date
    05-30-2013
    Location
    Isreal
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: Issue with Select Case and for loop

    That did the trick thank you for your help

+ 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. [SOLVED] Select Case - if no match issue
    By D_N_L in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2014, 11:57 AM
  2. [SOLVED] Using a loop with Select Case
    By greglittle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2012, 10:45 AM
  3. [SOLVED] Select Case with a Loop
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2012, 01:50 PM
  4. Select Case in a loop something like this possible?
    By scottr99 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-29-2012, 05:31 PM
  5. Loop Select Case
    By garretonufer in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 09-24-2009, 05:25 PM
  6. Select Case with Loop or For Next
    By garretonufer in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-24-2009, 07:12 AM
  7. How to use Select Case in a loop
    By mikea3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2008, 02:09 AM
  8. Select Case - issue
    By George in forum Excel General
    Replies: 7
    Last Post: 03-17-2006, 01:25 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