How do i check if the a named range is empty
Thanxxxx that did the job
If i hadn't you guys .....
Luc
"Mike H" schreef in bericht
...
Hi,
One way
If WorksheetFunction.CountA(Range("risks")) = 0 Then
MsgBox "Empty"
Else
MsgBox "Not Empty"
End If
Mike
"Luc" wrote:
I have a named range ("Risks").
How can i check if this named range contains no values.
If the range is totaly empty, then i have to show a message box and exit
the
sub.
Thanxxxxx,
Luc
.
|