| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i check if the a named range is empty
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i check if the a named range is empty
If Application.CountA(rng) = rng.Cells.Count Then MsgBox "Is empty End If HTH Bob "Luc" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i check if the a named range is empty
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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste to next empty cell in named range of cells | Excel Discussion (Misc queries) | |||
| SUM() of empty dynamic named range returns #N/A | Excel Programming | |||
| Trapping error from Empty Dynamic Named Range | Excel Programming | |||
| Check for empty range in vba | Excel Discussion (Misc queries) | |||
| Named Range - Empty columns | Excel Programming | |||
![Luc[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
