ExcelBanter - Testing for content in Range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Testing for content in Range (https://www.excelbanter.com/excel-programming/303952-testing-content-range.html)

Jim McLeod[_3_]

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...

Frank Kabel

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...

All times are GMT +1. The time now is 06:03 AM.