一段vba语句，竟引起表格异常，请大侠帮忙看看

adane

我用的是WPS表格，用下面这段语句，就会引起WPS表格自带的查批功能失效。
----------------------------------
Sub 清除带底色()


    Dim c As Range, rng As Range, firstAddress$, m&, d As Object, shp As Shape


    Set d = CreateObject("scripting.dictionary")


    With Application.FindFormat


        .Clear


        .Interior.Color = RGB(221, 235, 247)


    End With


    With ActiveSheet.UsedRange


        Set c = .Find(What:="", SearchFormat:=True)


        If Not c Is Nothing Then


            firstAddress = c.Address


            Do


                m = m + 1


                If m > 1 Then Set rng = Union(rng, c.MergeArea) Else Set rng = c.MergeArea


                d(c.Address) = ""


                Set c = .Find(What:="", After:=c, SearchFormat:=True)


            Loop While Not c Is Nothing And firstAddress <> c.Address


        End If


    End With

adane

Sub 清除带底色()

    Dim c As Range, rng As Range, firstAddress$, m&, d As Object, shp As Shape

    Set d = CreateObject("scripting.dictionary")

    With Application.FindFormat

        .Clear

        .Interior.Color = RGB(221, 235, 247)

    End With

    With ActiveSheet.UsedRange

        Set c = .Find(What:="", SearchFormat:=True)

        If Not c Is Nothing Then

            firstAddress = c.Address

            Do

                m = m + 1

                If m > 1 Then Set rng = Union(rng, c.MergeArea) Else Set rng = c.MergeArea

                d(c.Address) = ""

                Set c = .Find(What:="", After:=c, SearchFormat:=True)

            Loop While Not c Is Nothing And firstAddress <> c.Address

        End If

    End With

    If m > 0 Then

        rng.ClearContents

        'rng.Interior.ColorIndex = xlNone 删除底色

        For Each shp In ActiveSheet.Shapes

            If d.Exists(shp.TopLeftCell.Address) Then shp.Delete

        Next

    End If

End Sub

adane

二楼是完整的语句，只要执行这个宏，表格的查找功能就会失效，查找不到任何的数据。必须关闭表格后再打开才会正常。或者只 要我不执行这个宏，查找功能就一直是正常的。

adane

大侠啊啊啊啊