Run-time error '1004' when closing Excel

[Jono]

Hello,

I've been getting this message when closing excel (not necessarily when closing the workbook by itself, but when closing Excel and the workbook at the same time):

--------------------------
Run-time error '1004':
Method of 'Worksheets' of object '_Global' failed
--------------------------

When I hit Debug, it highlights the code marked below:

--------------------------
Private Sub AttachSelect_Ch ange()

Dim X As Integer
Dim Y As Integer

With Worksheets("Src ").Range("A1:A1 00") ' This line highlighted
Set C = .Find(AttachSel ect.Text, LookIn:=xlValue s)
If Not C Is Nothing Then
firstAddress = C.Address
Do
X = C.Row
Y = Worksheets("Src ").Cells(X, 3).Value
ActiveWindow.Sc rollRow = Y
Set C = .FindNext(C)
Loop While Not C Is Nothing And C.Address <> firstAddress
End If
End With

End Sub
--------------------------

Anyone have any ideas? The worksheet running the code is "Attachment s" - not "Src"

If anyone has any ideas, I would love to kill this pesky message!!!

Thanks in advance