VBA dropdown list and need to loop through it

[tatendatiffany]

I am trying to do a loop that runs throught all the different tables specified on a drop down list. the range containing the dropdown list is GESTATUS and the worksheet is worksheet 2 (element) is the name of the sheet. How would i go about doing this.

 

[Mike Blackman]

Hi,

Somethig like this?

Sub MyLoop()

    Dim rngCell As Range
    
    For Each rngCell In Range("GESTATUS")
        'Your Code Here
    Next rngCell

End Sub

 

[tatendatiffany]

Hi,

Thank you very much let me try it.
but another quick question where said ' code here' what do i put there because i thought the loop was the code.... do i add a query that says were the result should be displayed.

*sorry about the dumb question am a beginner trying to understand as much as i can