| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop Do While at Null
Should this do it? "Loop Until IsEmpty(ActiveCell.Cells)"
"Tom Ogilvy" wrote: i = 1 do while not isempty(cells(i,1)) cells(i,1).interior.colorIndex = 3 i = i + 1 Loop i = 1 Do cells(i,1).Interior.ColorIndex = 3 i = i + 1 Loop until isempty(cells(i,1) -- Regards, Tom Ogilvy "Dave" wrote: What is the function to end a Do While statemnet when encountering a null, blank or empty cell? Thank you Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Failed to save table attributes of (null) into (null). | Excel Discussion (Misc queries) | |||
| How do I stop chart from plotting null values as zeros in excel 20 | Charts and Charting in Excel | |||
| COUNTIF says Null = Blank but Blank < Null | Excel Worksheet Functions | |||
| How do you stop excel from charting empty cells/null values as zer | Charts and Charting in Excel | |||
| cell value based on null/not null in another cell | Excel Worksheet Functions | |||
Threaded Mode
