str2

evening all having a bit of a problem i have some data that is exported as follows <tbody> 000 012 280 B WEBBING 000 012 499 HOSE 000 050 300 A F7M PAINT PENCIL 000 051 446 AP USB CABLE 000 051 446 Q WIR.HARN. 000 051 700 C BRACKET 000 054 635...

Hi, Looking to see who could modify this code so that it works with 1) Excel Tables & 2) More than 2 criteria. Ultimately, I want to display to the user what the filtered content is showing. Function AutoFilter_Criteria(rng As Range) As String'This will allow you to see Auto Filter Criteria...

I use this code to copy and paste addresses into a excel sheet and it works well. However if there are blank lines between the name, address and city/state lines it fails. How can I modify it to remove the blank lines? Sub SameAsBillTo() Application.ScreenUpdating = False...

Below is the code for a userform that im working on. But have str1 & str2 combining but if the user does not select str1 which is a list box it comes up a error. any way around this? Private Sub CommandButton1_Click() Dim RowCount As Long Dim ctl As Control Dim str1 As String Dim str2 As String...

I have a big problem where im trying to look for similarities and I just built a working code however its way to slow :/ I thought maybe the Similarity function I call was the bottleneck but just writing a simple "1" to each of these cells also took quite awhile Sub FindSimilarity() Dim lr As...

Hi guys Ive used all the stuff ive learned over the last 6 months to create this code which basically search for duplicates. Sub DuplicateSearch() Dim lr, i, j, k, m As Long Dim str As String, str2 As String Dim vData, vResult As Variant Dim vSearch, vOdd, vOdd2 As Variant Dim sheet As...