| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run aloop using a list
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run aloop using a list
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 -- Gary''s Student - gsnu200719 "answer33" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run aloop using a list
Thank's for your help,
Sebastien "Gary''s Student" wrote: 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 -- Gary''s Student - gsnu200719 "answer33" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Run aloop using a list
You are welcome.
Submit another post if you need more assistance. -- Gary''s Student - gsnu200719 "answer33" wrote: Thank's for your help, Sebastien "Gary''s Student" wrote: 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 -- Gary''s Student - gsnu200719 "answer33" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing List A to List B and add what's missing from List B | Excel Discussion (Misc queries) | |||
| create new list from list A, but with exclusions from a list B | Excel Worksheet Functions | |||
| validation list--list depends on the selection of first list | New Users to Excel | |||
| list 1 has 400 names List 2 has 4000. find manes from list 1 on 2 | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Linear Mode
