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