Run aloop using a list

[Guest]

Hi,

I would like to run a macro in loop using a list already prepared in Excel.
How can I program it?

Regards,

Sébastien

 

[Guest]

You can use the For Loop. Let's say your list is in column Z from Z12 to Z20
and you want to process the list - Output them:

Sub do_list()
Dim r As Range
Set r = Range("Z12:Z20")
For Each rr In r
MsgBox (rr.Value)
Next
End Sub

 

[Guest]

Thank's for your help,

Sebastien

You can use the For Loop. Let's say your list is in column Z from Z12 to Z20
and you want to process the list - Output them:

Sub do_list()
Dim r As Range
Set r = Range("Z12:Z20")
For Each rr In r
MsgBox (rr.Value)
Next
End Sub

 

[Guest]

You are welcome.
Submit another post if you need more assistance.