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

Can anybody help ??

Les Stout

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

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 ***

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

Les Stout wrote:

> Hi all, i have put the following in my code:
> Range("N1:P1").AutoFilter
> It puts the filter in but they do not work correctly ??
>
> Can anybody help ??
>
> Les Stout
>
> *** Sent via Developersdex http://www.developersdex.com ***

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

(E-Mail Removed) wrote:
> Hi
> Works for me. You need column headers in N1:P1, not data - so your data
> starts in row 2.
> regards
> Paul
>
> Les Stout wrote:
>
> > Hi all, i have put the following in my code:
> > Range("N1:P1").AutoFilter
> > It puts the filter in but they do not work correctly ??
> >
> > Can anybody help ??
> >
> > Les Stout
> >
> > *** Sent via Developersdex http://www.developersdex.com ***

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 Stout wrote:
>
> 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 ***

--

Dave Peterson

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


Dave Peterson wrote:
> 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 Stout wrote:
> >
> > 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 ***
>
> --
>
> Dave Peterson