Macro repeating

[Bob]

How do I get a macro to repeat itself through a column?

 

[Frank Kabel]

Hi Bob
not quite sure what you want to achieve but may be the following will
suit:
sub foo()
Dim rng as range
Dim cell as range
set rng = range("A1:A100")
for each cell in rng
'do something with the cell range object
next
end sub