I'm really not sure whay you can do with this, but is this what you are
wanting?

Sub SelectionLoop()

Dim i As Long

For i = 1 To 7
Cells(i, "A").Select
Next i

End Sub

Hope this helps! If so, please click "YES" below.
--
Cheers,
Ryan


"DOOGIE" wrote:

I am writing a macro for a spreadsheet where I have values stored in one
column. I want to run a loop where each time the loop runs, I select each
cell in the column. For example, my values are stored in column A, cells 1
through 7. On loop 1 I want to select cell A1, loop 2 select cell A2, loop 3
select A3 and so on. How can I set this up in a macro to increment cell
selection as I move through my loop?