like operator

  1. H

    "Like" operator not working properly

    I have a macro to search duplicate file name in excel file (LogFile.xlsx). If found show it on macro file (SearchDuplicate.xlsm) otherwise insert the file name in logfile. Please !! help ! Sub Button1_Click() Dim MyFolder As String, MyFile As String Dim LastRowLogFile As Long, m As Long Dim...
  2. S

    2 Part question: Using Like & refining code

    Right off the bat, if this should be broken out into 2 separate threads, I apologize and will adjust accordingly (if possible). I just see the two issues somewhat related and so thought that perhaps I could get them both done in one swing. Part 1: The two workbooks I am using are: WorkbookA &...
  3. D

    VBA Like Operator

    Hello, I have been using the Like operator in VBA to activate sheets if they have a given start to their name. See example below: Sheet name = "AI. 1234567" Identifying start to name = "AI." The code for this would be as follows: For Each sh In Worksheets If sh.name Like "AI.*" Then...
  4. B

    VBA: Copy a string pattern with wildcards from an array to a new column

    Hi, I am stuck on this one so any help is more than welcome :D I have a column with text and I need to copy any account numbers to a new column. The account numbers vary so I have to use wildcards, but the other problem is that the account numbers can have 3 different patterns (hyphen (example...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top