checking blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
Back
Top