Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to find string in a column or row
Hi,
Currently I have code that functions properly - but I'm sure there ha to be a better way of coding! :-) Basically - whenever I search for a string in a column or row - righ now - I use a For Loop until rng.Rows.Count or rng.Columns.Count - an then inside my loop I query to see if a cell contains the cell valu 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! -Robi -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to find string in a column or row
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL function;find string in entire column & return cell referenc | Excel Worksheet Functions | |||
Find a text from a column in a text string within another column? | New Users to Excel | |||
Find a string within a column | Excel Discussion (Misc queries) | |||
Macro to find text string in a column and paste data in another | Excel Discussion (Misc queries) | |||
Find text string in column? | Excel Discussion (Misc queries) |