Testing for content in Range

J

Jim McLeod

Hi Guys,

Is it possible to test a range for content using VBA without visiting each cell in a for each loop?

Regards,

Jim...
 
F

Frank Kabel

Hi
you could use something like
msgbox application.countif(your_range,your_condition)
within VBA

or use the Find method within VBA
 
Top