Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IS BLANK checking 2 Cells | Excel Worksheet Functions | |||
checking for blank cells when using vlookup | Excel Worksheet Functions | |||
Checking Blank Cells | Excel Worksheet Functions | |||
Checking for all blank cells in a range orcolumn. | Excel Programming | |||
Checking iorAll blank cells in a column. | Excel Programming |