vbtextcompare

Hi everyone, I have two excel files, and I need to compare the content to find out what’s different between them. What’s the best way to do this? I’m open to using any tool. Any recommendations for reliable and easy-to-use solutions would be appreciated! Thanks in advance!

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...