Text Comparison

  • Thread starter Thread starter bilswi
  • Start date Start date
B

bilswi

I have a need to test the cell contents to determine if the cel
contains specific text in any of its contents. This is like using th
"find" feature.

I want to test if a cell contains "LA" for instance. If true then
want to copy the entire cell and then compare it to another cell.

Any help?

Thanks Bil
 
For X = 1 to len(Cells(1,1))-1 step 1

If Mid(Cells(1,1),X,2) = "LA" then
MyString = Cells(1,1).value
Exit for
End If

Next
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i want a cel is to follow another cel's content but it shows a zero(0) if the first cel is empty!? 3
VBA set thick borders around non empty cells in range 0
String comparison 6
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
SELECT PART OF A TEXT IN A CELL 1
Issues with InStr 2
Number Stored As Text 2
Changing the text of a label on a Userform 1

Back
Top