checking blank cells
 

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!

checking blank cells
 

You need to tell vba what "c8" is.
Do Until IsEmpty(Range("C8").Offset(a,0)) 'Don't need = True because
IsEmpty is Boolean
a = a + 1
Loop

HTH

Die_Another_Day

Arne Hegefors wrote:
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!