I want to loop through cells starting with c8 and stop when the cell has no
content. How do you write code for that?
I tried:
Do Until IsEmpty(c8.Offset(a, 0)) = True
a = a + 1
Loop

but that is wrong. Please help me out! Thanks!