Results 1 to 20 of 125

Thread: Combine recursive listing with excluded code

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #11
    I want to extend my code to have a parent folder list in column J and an exclude list in column K. The below code is in module 2. I found that instead of writing each parent folder in "sPathTop", I could've listed the parent folders in column J (or any other column) and then ran the main code. I just don't know how to run the main code for each parent folder in column J while taking into account the exclude list in column K. In other words, how can I include the below code to run with my main code? Thanks

    Sub examplearray()
        Dim testarray() As String, size As Integer, i As Integer, x As Variant
        size = WorksheetFunction.CountA(Range("A1", Range("A1").End(xlDown)))
        ReDim testarray(size)
        'Range("L2") = LBound(testarray)
        'Range("L3") = UBound(testarray)
        For i = 1 To size
            testarray(i) = Range("A" & i).Value
        Next i
    End Sub
    Last edited by Aussiebear; 07-10-2024 at 01:29 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
  •