| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if range containing values
hi,
how can I check, if a cell range ( range("A1", "A5") ) contains any values? i need to know, if the cells are empty. thanks, markus |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check if range containing values
J.E. McGimpsey wrote:
Dim numVals As Integer numVals = Application.CountA(Range("A1:A5")) If numVals = 0 Then MsgBox "All Empty" thank you! :) markus |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check if range containing values
Pieter Kuyck wrote:
WorksheetFunction.CountA(Range("A1:A5"))=0 thank you! :) markus |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to check if the values in a range of cells are greater than 0 | Excel Worksheet Functions | |||
| Check the interval of a cell withni a range of values | Excel Discussion (Misc queries) | |||
| check for FALSE values in a range of cells in VBA | Excel Discussion (Misc queries) | |||
| Check if rounded cell values fall within a range | Excel Discussion (Misc queries) | |||
| Q: check a range values | Excel Discussion (Misc queries) | |||
Linear Mode
