Hi All

I use the below macro which works extremely well (where the variable cFnd is set to a cell with my search criteria)... is there any way to modify it to also find words where the first letter is capitalised (or ignore letter case altogether)

i.e. now if I search "hello" it will not highlight text with "Hello" - I would like it to highlight both "hello" and "Hello"

At the moment I have to run it twice with the cFnd variable modified... but that makes it very slow !

y = Len(cFnd)
For Each rng In Selection
  With rng
    m = UBound(Split(rng.Value, cFnd))
    If m > 0 Then
      xTmp = ""
      For x = 0 To m - 1
        xTmp = xTmp & Split(rng.Value, cFnd)(x)
        .Characters(start:=Len(xTmp) + 1, Length:=y).Font.ColorIndex = 3
        .Characters(start:=Len(xTmp) + 1, Length:=y).Font.Bold = True
        xTmp = xTmp & cFnd
      Next
    End If
  End With
Next rng
Any help gratefully received !

Best
James