Advise on Autofilter

[Les Stout]

Hi all, i have put the following in my code:
Range("N11").AutoFilter
It puts the filter in but they do not work correctly ??

Can anybody help ??

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

 

[Les Stout]

Hi, further to my last message, the filters work if i put filters in the
whole of row 1 ? Is there a rule for this, as if i just put the filter
in the three cells, they do not work ??

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***

 

[paul.robinson]

Hi
Works for me. You need column headers in N11, not data - so your data
starts in row 2.
regards
Paul

 

[Les]

Hi Paul, it is in the header row & my data starts in row 2.

 

[Dave Peterson]

I try to specify the range that I want the filter applied to:

dim myRng as range
with worksheets("sheet9999")
set myrng = .range("P1:N" & .cells(.rows.count,"P").end(xlup).row)
end with

myrng.autofilter

====
Sometimes if you have gaps in the data/rows, your filter won't do what you
expect.

 

[Les]

Thank you so much Dave, that did the trick 100%

I try to specify the range that I want the filter applied to:

dim myRng as range
with worksheets("sheet9999")
set myrng = .range("P1:N" & .cells(.rows.count,"P").end(xlup).row)
end with

myrng.autofilter

====
Sometimes if you have gaps in the data/rows, your filter won't do what you
expect.