Hi all out there,

I'm a little confused while testing an Subroutine on both the Excel 2007 (my Developer Version on my home Computer) and Version 97 (installed on all the workstations in the company).
Version 2007 will NOT find my Border Formattings, as opposed the 97 Versions does the job pretty well. Ofcourse the Testroutine is the exact same on all the Computers (4 to be exact) I tested the code. Here's the Code which resides in a WorkBoook Module:

Sub test()
    Dim c As Range
    Dim r As Range
    
    Application.FindFormat.Clear
    With Application.FindFormat.Borders(xlEdgeBottom)
        .Weight = xlThick
        .LineStyle = xlContinuous
    End With
    
    With Range("D10").Borders(xlEdgeBottom)
        .Weight = xlThick
        .LineStyle = xlContinuous
    End With
    
    Set r = Range("D1:D20")
    Set c = r.Find(what:="", searchformat:=True)
    If Not c Is Nothing Then
        Debug.Print "Found"
    End If
End Sub
If I test / search for a FONT format, Version 2007 DOES find it though.
Does anyone have any idea what could course this.

Thanks a lot