J
jermsalerms
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-------
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-------