Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
empty range
How do I write a procedure to look at a range of cells, and if all the cells
are empty do one thing, or if at least on cell in the range has something in it do something else? I tried Sub a() Dim r As Range Set r = Range("rng") r.Select If r is empty Then MsgBox ("nothing") Else MsgBox ("something") End If End Sub That doesn't seem to work. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Last Empty Row in Range | Excel Programming | |||
Range ... how to know if it is empty | Excel Programming | |||
Finding next empty empty cell in a range of columns | Excel Programming | |||
Range empty? | Excel Programming | |||
why is range empty? | Excel Discussion (Misc queries) |