I have the following code: ActiveSheet.ShowAllData
what is the code to indicate if the auto filter is not on to keep running
the rest of the VB code?

thanks

with Activesheet
if .filtermode then
.showalldata
end if
end with



pgarcia wrote:
>
> I have the following code: ActiveSheet.ShowAllData
> what is the code to indicate if the auto filter is not on to keep running
> the rest of the VB code?
>
> thanks

--

Dave Peterson

Never mind, just found what I was looking for.

With ActiveSheet
If .FilterMode Then
.ShowAllData
End If
End With

"pgarcia" wrote:

> I have the following code: ActiveSheet.ShowAllData
> what is the code to indicate if the auto filter is not on to keep running
> the rest of the VB code?
>
> thanks

Cool, thanks. I found a post that you wrote back in 2004 with that same code.
Thanks

"Dave Peterson" wrote:

> with Activesheet
> if .filtermode then
> .showalldata
> end if
> end with
>
>
>
> pgarcia wrote:
> >
> > I have the following code: ActiveSheet.ShowAllData
> > what is the code to indicate if the auto filter is not on to keep running
> > the rest of the VB code?
> >
> > thanks
>
> --
>
> Dave Peterson
>

Some questions (and answers!) don't change <vbg>.

pgarcia wrote:
>
> Cool, thanks. I found a post that you wrote back in 2004 with that same code.
> Thanks
>
> "Dave Peterson" wrote:
>
> > with Activesheet
> > if .filtermode then
> > .showalldata
> > end if
> > end with
> >
> >
> >
> > pgarcia wrote:
> > >
> > > I have the following code: ActiveSheet.ShowAllData
> > > what is the code to indicate if the auto filter is not on to keep running
> > > the rest of the VB code?
> > >
> > > thanks
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson