Replace Around Wilcards

[smitpau]

Hi,

Wonder if someone maybe able to help with this say I have the following names below.

If I search BS??BD it will find the two current results but if I try to keep the 3rd and 4th characters as 01,02 but update the Test for Final using BS??Final it will then insert the ??

Is there a way to essentially leave the searched wildcard values as they are?

PS appreciate you could search Test and replace with Final but in this case I need the specific search to avoid finding other non-relevant cells (like columns BD).


Current
BS01BD
BS02BD

Updated
BS01Final
BS02Final


Hope I've explained it clearly.

Thanks for reading

 

[Fluff]

Sorry I couldn't help more & thanks for the feedback.

 

[smitpau]

To round this off, found the code listed below and linked below which bulk changes named ranges very well so avoids this problem in the first place.

Sub NameChanger()
    Dim arNames()
    Dim nm As Name
    Dim i As Integer
    
    arNames = Sheets("Sheet2").Range("NameList").Value
    For i = LBound(arNames) To UBound(arNames)
        For Each nm In ActiveWorkbook.Names
            If nm.Name = arNames(i, 1) Then
                nm.Name = arNames(i, 2)
            End If
        Next nm
    Next i
End Sub

VBA Code to Rename a Defined Range

I am trying to find a way to use VBA to change the name of a Defined Range. Everything I have found so far creates a new range and then deletes the old range. I have used the existing named ranges throughout a large workbook, so I don't want to delete the existing named ranges. Also, I have...

www.mrexcel.com