like function

Hi All, I have a file with a LOT of data, particularly names, so I wrote a quick search macro that opens and closes the columns based on the entry from the user so they don't have to scroll through thousands of columns. It works wonderfully, and is actually pretty quick for the amount of...

Hello, I'm utilizing MS query in excel and can get the user to input a value in a cell and then the report refreshes for this specific criteria, say if they select North or South. However I want a report that uses this cell but brings back all data that meets that criteria, so in the example...

Hello, I am using the Like function, but it isn't working on all of the cells. column B has company names. I am trying to get rid of names that have the word sample in them. my code: 'getting rid of sample plans For Each cell In Range("B2:B" & lastrow) If cell Like "*Sample*" Then...

hi, I have macro where I'm opening workbooks and for diffrent sheets I want to run code. ... Set wb = Workbooks.Open(strPath2 & strFile2) Dim myArray() As String Dim myCount, NumShts As Integer NumShts = wb.Worksheets.Count ReDim myArray(1 To NumShts) For myCount = 1...

I need help creating a function to compare strings; probably using regular expressions since it is a bit tricky. We have six strings: String 1: "V06+K73+U55+M67" String 2: "!M43" String 3: "!U67" String 4: "V06" String 5: "" String 6: "" In this case, "!" means 'not' so this statement would...

Suppose I have two strings: U98 & K11+P46+M67+U98 ..All I need to know is how to return True if the first string is in the second or False if it is not. I have been trying to use this: str1Mask = curStrCell.Value Like strCell.Value If str1Mask = True 'Do whatever End If Where curStrCell is...

Hello, i am tring to run a "For Each" Loop in excel with the condition that if cells in selecton trends ("Like") with another range. Range("A:A").Select For Each MyCell In Selection If Mycell.value Like Range("B:B") Now I am not sure if I can run Like function against a range ... it works if...

Hey guys, i know that this works: bool = "*abc*" like "xabcx" 'true dim a as string, b as string a = "abc" b = xxxacbxxx" if True = a like b then '... end if Is it possible to use characters like * ? # in the second code: if True = *a* like b then 'I know, that does not work I hope...

Hi All, I'm facing a problem in executing the following code snippet : sub strtest() X = [FACT*]*[!FACT*DM] tbl_nm = "FACT_TSS_PRDCT_ATTRBTS_ABC" If tbl_nm Like X Then MsgBox "TRUE" End Sub This means that if tbl_nm (Table Name) starts with FACT but does not end with DM, the MSGBOX should...