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