S
Sandy
I have a named range (dynamic) called 'HomeRecordsAll' which refers to a
range currently ("A1:GL28") on Sheets("HomeCourse").
The name refers to :-
'=OFFSET(HomeCourse!$A$9,0,0,COUNT(RecordOfRounds!$A$52:$A$10000)+1,194)'.
I am attempting to incorporate the 'HomeRecordsAll' into code for an
advanced filter.
The following does not work:-
Sheets("HomeCourse").Select
Range("HomeRecordsAll").AdvancedFilter Action:=xlFilterInPlace, _
Criteria:=Range("A1:E2"), Unique:=False
Any help appreciated.
Thanks
Sandy
range currently ("A1:GL28") on Sheets("HomeCourse").
The name refers to :-
'=OFFSET(HomeCourse!$A$9,0,0,COUNT(RecordOfRounds!$A$52:$A$10000)+1,194)'.
I am attempting to incorporate the 'HomeRecordsAll' into code for an
advanced filter.
The following does not work:-
Sheets("HomeCourse").Select
Range("HomeRecordsAll").AdvancedFilter Action:=xlFilterInPlace, _
Criteria:=Range("A1:E2"), Unique:=False
Any help appreciated.
Thanks
Sandy