if application.Countif(rng.EntireRow,"xyz") 0 then
--
Regards,
Tom Ogilvy
strataguru wrote in message
...
Hi,
Currently I have code that functions properly - but I'm sure there has
to be a better way of coding! :-)
Basically - whenever I search for a string in a column or row - right
now - I use a For Loop until rng.Rows.Count or rng.Columns.Count - and
then inside my loop I query to see if a cell contains the cell value
I'm looking for..... for example
For i = 1 to rng.Rows.Count
If ws.Cells(i, 1).Value = "xyz" Then
MsgBox("Found string")
End If
Next i
Is there better way to code this ? - where I can say something like:
If rng.Rows.Contains("xyz") Then
MsgBox("Found string")
End If
Thanks in advance!
-Robin
---
Message posted from http://www.ExcelForum.com/