Autofill doesn't give the number of records filtered any more
 

On our training machines, autofilter no longer gives the number of records on
the bottom left, it now say READY, I know that Filter mode shows sometimes,
what's changed on the laptops?

Thanks

Diane

Autofill doesn't give the number of records filtered any more
 

Try,

Right click the bar (by ready) and select what you want displayed.

Mike

"DianeG" wrote:

On our training machines, autofilter no longer gives the number of records on
the bottom left, it now say READY, I know that Filter mode shows sometimes,
what's changed on the laptops?

Thanks

Diane

Autofill doesn't give the number of records filtered any more
 

Sorry Mike,

That's not quite what I was looking for, it should display for example "4
records of 16"

Thanks

diane



"Mike H" wrote:

Try,

Right click the bar (by ready) and select what you want displayed.

Mike

"DianeG" wrote:

On our training machines, autofilter no longer gives the number of records on
the bottom left, it now say READY, I know that Filter mode shows sometimes,
what's changed on the laptops?

Thanks

Diane

Autofill doesn't give the number of records filtered any more
 

Hi Diane

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlautofilter02.html#Count

--
Regards

Roger Govier


"DianeG" wrote in message
...
On our training machines, autofilter no longer gives the number of
records on
the bottom left, it now say READY, I know that Filter mode shows
sometimes,
what's changed on the laptops?

Thanks

Diane

Autofill doesn't give the number of records filtered any more
 

Thanks Roger but that it didn't mention it either, it's a real mystery
because we've always got a total before, now it's stuck on READY.

"Roger Govier" wrote:

Hi Diane

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlautofilter02.html#Count

--
Regards

Roger Govier


"DianeG" wrote in message
...
On our training machines, autofilter no longer gives the number of
records on
the bottom left, it now say READY, I know that Filter mode shows
sometimes,
what's changed on the laptops?

Thanks

Diane

Autofill doesn't give the number of records filtered any more
 

Hi

Then from a previous post of Nick Hodge

Opening the VBE (Alt+F11) and if there is not an immediate window
showing,
go to ViewImmediate window. (Ctrl+G). In here type

Application.StatusBar=False


This returns control of the status bar to Excel, as to why this may
have
happened...??????? (Exit VBE an Excel)


You could try this to see if it helps.

--
Regards

Roger Govier


"DianeG" wrote in message
...
Thanks Roger but that it didn't mention it either, it's a real mystery
because we've always got a total before, now it's stuck on READY.

"Roger Govier" wrote:

Hi Diane

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlautofilter02.html#Count

--
Regards

Roger Govier


"DianeG" wrote in message
...
On our training machines, autofilter no longer gives the number of
records on
the bottom left, it now say READY, I know that Filter mode shows
sometimes,
what's changed on the laptops?

Thanks

Diane

Autofill doesn't give the number of records filtered any more
 

Thanks a lot for that, I don't know much about VBA but it will be interesting
to give it a go

Regards

Diane

"Roger Govier" wrote:

Hi

Then from a previous post of Nick Hodge

Opening the VBE (Alt+F11) and if there is not an immediate window
showing,
go to ViewImmediate window. (Ctrl+G). In here type

Application.StatusBar=False


This returns control of the status bar to Excel, as to why this may
have
happened...??????? (Exit VBE an Excel)


You could try this to see if it helps.

--
Regards

Roger Govier


"DianeG" wrote in message
...
Thanks Roger but that it didn't mention it either, it's a real mystery
because we've always got a total before, now it's stuck on READY.

"Roger Govier" wrote:

Hi Diane

Take a look at Debra Dalgleish's site
http://www.contextures.com/xlautofilter02.html#Count

--
Regards

Roger Govier


"DianeG" wrote in message
...
On our training machines, autofilter no longer gives the number of
records on
the bottom left, it now say READY, I know that Filter mode shows
sometimes,
what's changed on the laptops?

Thanks

Diane