VBA Help

[D03274256]

In vba how would I cycle through all the cells in column A (starting with A2) that have data, and store the data?
Meaning, let me take the value from A2....run code, then come back and take the value from A3, run code, then value from A4...all the way until column A is null?

 

[Jonmo1]

Something like

Sub Test()
Dim lr As Long, c As Range
lr = Cells(Rows.Count,"A").End(xlup).Row
For Each c In Range("A2:A" & lr)
    'do some stuff using c as the range
    c.Interior.Color = 3
Next c
End Sub

 

[kevatarvind]

try below

Sub Test()
Range("A2").Select
Do Until ActiveCell.Value = ""
'do what u want some stuff like below all cell will highlight
ActiveCell.Interior.ColorIndex = 6
ActiveCell.Offset(1, 0).Select
Loop
End Sub

 

[D03274256]

How could I capture the text of the current cell?