S
Sandy
I am receiving the following error for the code listed below:
'Run-time error 1004'
'Application-defined or object-defined error'
'Sub filter()
Sheets("RecordOfRoundsDetailed").Range("AllDetailedRecords"). _
AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("RecordOfRoundsDetailed").Range("DetailedFilterCriteria"),
_
CopyToRange:=Sheets("HomeDetailed").Range("DetailedFilterDestination"),
_
Unique:=False
End Sub'
Names are as follows:-
AllDetailedRecords =
"=OFFSET(RecordOfRoundsDetailed!$A$52,0,0,COUNTA(RecordOfRoundsDetailed!$A$52:$A$65536),221)"
DetailedFilterCriteria = "=RecordOfRoundsDetailed!$A$1:$E$2"
DetailedFilterDestination = "=OFFSET(HomeDetailed!$A$52,0,0,1,221)"
When I compile the code it is ok.
Is there any way to establish which part of the code is causing the error or
is there any obvious problem with the code?
Sandy
'Run-time error 1004'
'Application-defined or object-defined error'
'Sub filter()
Sheets("RecordOfRoundsDetailed").Range("AllDetailedRecords"). _
AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheets("RecordOfRoundsDetailed").Range("DetailedFilterCriteria"),
_
CopyToRange:=Sheets("HomeDetailed").Range("DetailedFilterDestination"),
_
Unique:=False
End Sub'
Names are as follows:-
AllDetailedRecords =
"=OFFSET(RecordOfRoundsDetailed!$A$52,0,0,COUNTA(RecordOfRoundsDetailed!$A$52:$A$65536),221)"
DetailedFilterCriteria = "=RecordOfRoundsDetailed!$A$1:$E$2"
DetailedFilterDestination = "=OFFSET(HomeDetailed!$A$52,0,0,1,221)"
When I compile the code it is ok.
Is there any way to establish which part of the code is causing the error or
is there any obvious problem with the code?
Sandy