P
Peter
Hi Guys,
Sorry if this question has been asked/answered before but I couldn't
see it easily in a search.
I have a problem with autofilter in one particular worksheet, not all
of them.
In using autofilter via VBA I seem to get the last line of the
datatable irrespective of the criterion selected, i.e. in 613 rows of
dataI might get rows 34,45,67,98 which relate to my criterion but then
I get row 613 tagged on at the end. It happens for all my selections.
I've tried three different fixes and none worked
1) naming the exact range from row 5 (headers) column1 to row 613 col
22 as "dfilter1" and then using
Sheet12.Range("dfilter1").AutoFilter Field:=1, Criteria1:="Australia"
2) increasing the range dimensions to include rows beyond the last row
of data (i.e. lower row is now 615 not 613)
3) Including rows 5 to 65536 in my range name
I've also tried setting autoflter manually and still no joy.
I've never had this problem before - anyone else had it and sorted it?
Thanks
Peter
Sorry if this question has been asked/answered before but I couldn't
see it easily in a search.
I have a problem with autofilter in one particular worksheet, not all
of them.
In using autofilter via VBA I seem to get the last line of the
datatable irrespective of the criterion selected, i.e. in 613 rows of
dataI might get rows 34,45,67,98 which relate to my criterion but then
I get row 613 tagged on at the end. It happens for all my selections.
I've tried three different fixes and none worked
1) naming the exact range from row 5 (headers) column1 to row 613 col
22 as "dfilter1" and then using
Sheet12.Range("dfilter1").AutoFilter Field:=1, Criteria1:="Australia"
2) increasing the range dimensions to include rows beyond the last row
of data (i.e. lower row is now 615 not 613)
3) Including rows 5 to 65536 in my range name
I've also tried setting autoflter manually and still no joy.
I've never had this problem before - anyone else had it and sorted it?
Thanks
Peter