Cycling through a list of Names and repeating actions

[BeefNoodleSoup]

I have a list of Names (Name1, Name2, Name3, etc) and I want each Name to go through a series of actions:

1) Application.Goto Reference:="Name1"
2) Range("Name1_variable").Copy
3) Take some other action

4) Then, repeat the sequence for Name2


How do I go about doing this?

[jaslake]

Hi BeefNoodleSoup
I'd guess a "For Each" loop.

Please Login or Register  to view this content.

[Trebor76]

For reference, cross posted here

[BeefNoodleSoup]

I've defined a range of cells (A:A) as "referenceNames"
In this range there are strings/values scattered throughout (some cells are empty)
I then want to pick out these strings/values and assign them to "TableRef".
How do I step through all these strings? Below is my stab at this below with the part I'm confused about between ***

----- Code -----

Dim TableRef As String

For i = 1 To ***Code for counting the number of strings/values in referenceNames***
TableRef = Range("referenceNames")(i)
Some action requiring TableRef
Next i

[BeefNoodleSoup]

Thanks, I figured this out from the other forum