Loop within a loop based of condition

[ItalianPlatinum]

I am not sure the best way to ask this. I have large code that I am looking to modify to include an additional loop that encloses my current code that has loops within it. The complexity I am struggling with is once I wrap my code within the new loop then it'll always run 2 loops but I only want to run the additional loop if a cell value is present. Before unleashing my whole code on you does the ask make sense? I know it will be hard to formulate without the guts of the code.

 

[ItalianPlatinum]

For simplicity I can work around it I can run the With FT for single or bulk submission and do 2 loops always. I just need to add a few more if then statements to support.

I was worried about performance if I didn't need to run that process (call secdisc2 for WsFT) would it tack on more time but was only 10 additional seconds. So moot point

When testing this out I got Variable not defined for "cell"

For Each cell In CompList

 

[Engberg]

My bad, use these rows:

    Set BulkList = Range("BulkList")
    '<<><><><><>FIGURE OUT NEW LOOP FOR BULK LIST INCLUDING CODE BELOW Only if BUlk <> "" but not then do the exact same code<><><><><><>
Else
    For Each cell In BulkList.Cells ' <<<<<<<<<<< COULD ALSO BE SOMETHING LIKE "For bulkListIndex = 0 To BulkList.Count" IF THAT SUITS YOUR NEEDS BETTER >>>>>>>>>>>>
        'clear and set sheet filters

 

[ItalianPlatinum]

All good I ended up trying this way

'run for each fund
  j = 0
  Do Until WsFT.Range("BulkList").Offset(j, 0) = ""
    BulkList = WsFT.Range("BulkList").Offset(j, 0)

'my existing code

    j = j + 1
Loop

any drawback using this way, speed or efficiency you may think of? haven't fully test it yet anyways