Search results

Have Solved this myself, Code below for anyone wondering, ' Check if the base name is not already added to the collection If InStr(1, nm.Name, "CutOffTesting!_FilterD", vbTextCompare) = 0 _ And InStr(1, BaseName1, "_xlfn.", vbTextCompare) = 0 Then On...

I'm not worried about the duplicates, thats already sorted in the current code. I want to ignore/remove a specific name i.e. this section. ' Check if the base name is not already added to the collection If InStr(1, nm.Name, "CutOffTesting!_FilterD", vbTextCompare) = 0 Then On Error Resume Next...

Hi I have the following code, that puts all names from the name manager into a combo box and removes duplicates and other certain phrases, in this case "CutOffTesting!_FilterD". I want to remove/ignore a second phrase, but can't seem to get it to work. Private Sub UserForm_Initialize() '...