View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Die_Another_Day Die_Another_Day is offline
external usenet poster
 
Posts: 644
Default 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!