Looping
One way:
Dim cell As Range
Set cell = Range("A1")
Do Until IsEmpty(cell.value)
'do something
Set cell = cell.offset(1, 0)
Loop
In article ,
Darrel wrote:
I would like to execute my macro until it encounters an empty cell. How can
I check for an empty cell in a macro?
|