Consulting

  • Categories Widget (Show All)

  • Recent Articles

  • Recent Blog Posts

    ExcelAndAccess

    Free Microsoft Excel Training via the Excel University

    How would you like FREE Microsoft Excel training?



    How would you like the training to be live?

    Well...

    ExcelAndAccess 08-04-2017 07:45 PM
  • Recent Forum Posts

    albe.btz

    Control strings

    [QUOTE=xld;367766]Change

    [CODE]
    For Each CellaCerc In Sheets("Key Criteria").Range("A2", "A23")

    albe.btz Today, 08:32 AM Go to last post
    offthelip

    Searching with recursion

    Hopefully I understand better now try this, it does do the recursive bit.

    Dim str As String 
    Dim status As String 
    Dim inarr() 
    
    
    Formatting tags added by mark007

    offthelip Today, 08:32 AM Go to last post
    albe.btz

    Control Strings

    [QUOTE=albe.btz;367763]Hi Douglas,

    let me see if i got it right, this is my current code:

    [CODE]Sub breakSeasonality()

    albe.btz Today, 08:09 AM Go to last post
    xld

    Control strings

    Change

    [CODE]
    For Each CellaCerc In Sheets("Key Criteria").Range("A2", "A23")

    xld Today, 08:00 AM Go to last post
    JKwan

    Searching with recursion

    offthelip:
    Looking at it closely, it is not what I wanted. Your code looks at matching every From LSD to To LSD only, that is not what I wanted.

    JKwan Today, 07:42 AM Go to last post