My macro was working fine until I assigned a button to it and now I get
this error.

I removed the button and it still gives me the same error.

according to Miscrosofts website:

Form already displayed; can't show modally (Error 400)
Specifics

You can't use the Show method to display a visible form as modal. This
error has the following cause and solution:

You tried to use Show, with the style argument set to 1 vbModal, on an
already visible form.
Use either the Unload statement or the Hide method on the form before
trying to show it as a modal form.


I am not sure what this means or how to fix it...any suggestions.

I even tried to copy and paste everything into an new spreadsheet and
that didnt work.

This is my macro if it helps:

'---Start of Code-------
Option Explicit

Sub PullMatchingData()
Range("Database").AdvancedFilter _
Action:=xlFilterCopy, _
CriteriaRange:=Range("Criteria"), _
CopyToRange:=Range("Extract"), _
Unique:=False
End Sub
'---End of Code-------


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=517954