| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for content in Range
Hi Guys,
Is it possible to test a range for content using VBA without visiting each cell in a for each loop? Regards, Jim... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Testing for content in Range
Hi
you could use something like msgbox application.countif(your_range,your_condition) within VBA or use the Find method within VBA -- Regards Frank Kabel Frankfurt, Germany Jim McLeod wrote: Hi Guys, Is it possible to test a range for content using VBA without visiting each cell in a for each loop? Regards, Jim... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| testing range of cells for part of cell content | Excel Worksheet Functions | |||
| TESTING A RANGE OF CELLS | New Users to Excel | |||
| TESTING A RANGE OF CELLS | Excel Worksheet Functions | |||
| Testing a person's age to be within a range | Excel Worksheet Functions | |||
| Testing for existence of range | Excel Programming | |||
![Jim McLeod[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
