Down or over a cell

[DSNTNOENUF]

I want to record a macro that helps me cycle through a list in column A. I thought I could start with a cell d5.... record a macro =a1 and then =a2 then clicking back into a1 and stopping the recording and it would be set to continue the pattern down the column, but I am not correct. Can anyone tell help me to accomplish this? Thank-you in advance.

 

[portews]

Use a for... next loop to go thru the column

'this will find the last row in column A that has something in it
LastRow = ActiveSheet.Cells(ActiveSheet.Rows.Count, "A").End(xlUp).Row

'this will loop thru all the cells in the column that have something in it.
For i = 5 To LastRow
      'Use "Cells(i, 1)" instead of "Range("A1")" for whatever the recorded macro 
      'does in that cell and each time it loops, it will increment i.
Next

 

[Peter_SSs]

I want to record a macro that helps me cycle through a list in column A. I thought I could start with a cell d5.... record a macro =a1 and then =a2 then clicking back into a1 and stopping the recording and it would be set to continue the pattern down the column, but I am not correct. Can anyone tell help me to accomplish this? Thank-you in advance.

What exactly are you trying to achieve? That is, what is the result that you are trying to produce?

 

[DSNTNOENUF]

I would like to look at a record, click on an inserted button that is assigned to a macro, and have that macro advance the record one row down.

I see the above code posted by portews and just haven't been able to paste it into vba and get it to work for me.

If anyone is aware of a step by step youtube on the subject and would be so kind as to post the link I would very much appreciate it.