Selecting Name Using Table

[djhatrick12]

I have a table names PlantNames. It looks like this:

Please Login or Register  to view this content.

I want to start with Allen 1 in cell A1. Then do my code. Then Put Allen 2 in A1. Then do my code...all the way down to Lee 3.

It sounds really simple in my head but I can't think of how to do it through code.

[StephenR]

Why not loop through your list running the code for each entry?

[jwright650]

...to add to Stephan's post:

D/L the attached workbook "For Next looping thru names.xls" and check out macro "Step_thru_Names"


maybe this will give you some ideas of how to use the loop that Stephan was speaking about.

EDIT:whoops..nevermind this line...it does nothing "Dim xName As String"
move your windows around so you can watch....see Word.doc for example