instr

Hi guys, I'm trying to find this specific string "ppl" inside column W and fill down column X with TRUE / FALSE text. However it identifies even "apple" or "people" as TRUE as well. How can i make this code to only detect "ppl"? Thank you in advance :) Sub Sample() Dim LastRow As Long Dim...

Hi guys, Currently im try to search a cell if it contain two specific text inside it using InStr function. However it is not working. Anything am I missing here? If InStr(1, (Range("L1").Value), "Hello ") > 0 And InStr(1, (Range("L1").Value), "name ") Then The tresult im loking for should...

Hi Guys, I have the below code, which looks through a folder for files and copies the data into my open workbook. I need the code to look for filenames only containing a string of ABC, and if the filename contains anything else, then X (The sheet to copy) would be 1 to 2 (Instead of 3 to 3)...

Hi MrExcel and Everyone,~ I hope you're all doing great, fine and well at this time! I need help with the Instr function, or please let me know if a better function exists in Excel/VBA, that would work almost like fuzzy logic to look at data in a cell, and determine if a specific string is...

Good morning (or afternoon/evening). I have a vba application using forms and need to validate the user input to ensure none of a set of characters are being input. At the moment the set is )('@=`#~"!,. but this may grow. I was going to create a loop using instr, but wondered if there was a...

Is it possible to use InStr to where it will only return the position of a string if the phrase you are looking for is the entire cell. So say for example InStr(1, a(i, j), "err", 1) i want to find "err" in an array and not have it return "Sierra" only if the entire cell is "err" do i want it...

Greetings, I have a spreadsheet with names and addresses. In the name column, I need to compare all the words to a fixed list of terms, such as "borrower", "homeowner", "LLC", etc. I will be highlighting the row to look at individually. So far, I can get the code to work, but with only one...

I have this line of code, but I thought it was to get exact match. How can I get the exact match? If InStr(1, Cells(RowNum, 1).Value, "BA", vbTextCompare) > 0 Then

Could someone point me in the direction of a function that once InStr finds a substring, the function returns the entire word? For example, fx_WholeWord("I went to the theater and someone must have turned on the heater", "heat") would return both "theater" and "heater" Thanks y'all.

I'm abbreviating my descriptions to paint the picture. I have a userform that has 2 comboboxes on it. cmbPartNumber and cmbAccount cmbAccount is 2 columns populated from a worksheet For each row there is always a value in column 0 and sometimes a value in column 1 Click save on the userform...

Hi all, Is it possible to use multiple substrings with inStr? I want to test if the following characters are contained within mystring /, \, ?, %, *. Many Thanks

Hey All! I've been searching the forums in vain and am hoping someone out there can help. I have a dynamic named range ("FilterCriteria") and am trying to use it as an array for autofilter. I'd like to see if any of the "FilterCriteria" values appear in each cell in Column H. H is a helper...

I need the fastest way to look across a range of cells where each cell in the range contains a long string to see if any words in a list occurs in any of those cells. The first thing I did of course was to read the range of cells into an array, then I loop through my list (for each item in...

I have about 10 cells in a row that contain strings. These strings can be null to paragraphs of text. I need to find out if a particular key word exists in any of the cells, for each row through hundreds of thousands of rows, then this gets nested in another loop - so I need this to be fast...

If you call "Instr" with a null argument as in "Instr("Whatever","")" you always get back a 1. It should return a 0 indicateing that it didn't match anything. My solution:Function In_Str(Look_In, For_Text) ' Correcting "Instr" function. ' 7/3/18 Created. WML Prog = "In_Str"...

Hello, I was wondering if this was possible to do in vba code. I have a date in cell A15 and A16 ... 3/31/18 and 2/28/18 respectively. In the cells next to the date I need text that will pull the year and then some instr text or it can all be instr. I'm looking to type a file name like...

Dim LastRow As LongDim erow As Long Dim i As Long Dim strComp LastRow = Sheet2.Cells(Rows.Count, 1).End(xlUp).Row Sheet2.Select Range("A1").Select For i = 2 To LastRow strComp = Cells(i, 3) If InStr(1,strComp,"Fuel Consumed")= 1 Then erow = Sheet4.Cells(Rows.Count...

Greetings, I would like to build a simple macro to delete charts in the activeworkbook. I have the following written below: Dim x As Worksheet For Each x In ActiveWorkbook.Worksheets If InStr(1, ActiveWorkbook.Worksheet(x).Name, "Chart", 1) Then...

Hi again everyone, Q: what's the most efficient way to search for partial matches and populate results? I'm fairly beginner at vba but learning quickly. I have two very disorganized workbooks. Wb2 is where I will make all my edits. each workbook when exported has varying lines of code...

So I've run into a problem that I believe there is a solution for, however, I am not keen on how to implement the function. In the chart below you'll notice that all of the FALSE returns highlighted are actually TRUE. The code is as follows: Range("AC2").Formula =...