vbtextcompare

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

Hi, I am trying to create a macro that goes through the 'F' column of my worksheet and replaces the text and formatting of each cell dependant on what the cell currently contains. I am pretty new to using VBA in Excel so I'm not 100% sure what I am doing, but here's what I have so far: Sub...

I have a UDF I based off of a prior I was using. The prior one works just fine. But for some reason, this new one just returns a #VALUE error. I have 3 columns with Headers of: TD ST FLR In the FLR I input my UDF and it is based off of the TD & ST. Could someone give it a look over and...

I am doing an exercise where I am searching countless data entries in a bad format and finding what I need. Below is very sample data. I can find the midway point all the time fine. But it is getting the data between MidwayPoint and NewStart. I tried IF statements but keep getting locked up, and...

Hello All, Fairly new to vba and seeking a bit of help. I have this code that generates cell values in to a group with commas, but what i also need it to do is to remove all the duplicate values as well. Not sure is I can use the RemoveDuplicates method or if there's an easier way. Thanks for...

I have the following code: Debug.Print InStr(1, ActiveCell.Offset(0, 14).Value, "1", vbTextCompare) = 0 Debug.Print InStr(1, ActiveCell.Offset(0, 14).Value, "2", vbTextCompare) = 0 Debug.Print InStr(1, ActiveCell.Offset(0, 2).Value, "3", vbTextCompare) = 0 Debug.Print InStr(1...

hi all, i am busy with an formula, for a quite big project. i use this code: V_End_Of_Table = ActiveSheet.UsedRange.Rows.Count Dim cell As Range For Each cell In Range("CA2:CA" & V_End_Of_Table) If InStr(1, cell.Value, "fcnswanlrtm", vbTextCompare) > 0 Then Range("CX" &...

This is a bit of a follow-up to my question here, where I inquired on using an array for in-string values to not delete a row. Thanks again to Peter, this saved me a ton of time. I'm now trying to work out the opposite, more or less: to delete a row if any value in an array is present. I'm sure...