When I do an auto filter - sometimes the count of records
showing appears in the bottom left of excel and some
times it does not.

If I turn off auto calc then it shows up - ? why.

However do to my particular needs - turning off auto calc
is not a safe option.

So my main question is what can I do to create a routine
that would display say a combo box giving record count
(something small that can be closed) each time I do a
filter and disaoear when I say show all.

If a floating box is not a good idea I would hesitently
go for putting a cell in row 1 of all my sheets that gave
me a count of visable records at all times.

ANy thoghts on problem or suggests on how to do this
would be greatly appreciated.

Todd

Hi
see:
http://www.contextures.com/xlautofilter02.html#Count

--
Regards
Frank Kabel
Frankfurt, Germany


Todd F wrote:
When I do an auto filter - sometimes the count of records
showing appears in the bottom left of excel and some
times it does not.

If I turn off auto calc then it shows up - ? why.

However do to my particular needs - turning off auto calc
is not a safe option.

So my main question is what can I do to create a routine
that would display say a combo box giving record count
(something small that can be closed) each time I do a
filter and disaoear when I say show all.

If a floating box is not a good idea I would hesitently
go for putting a cell in row 1 of all my sheets that gave
me a count of visable records at all times.

ANy thoghts on problem or suggests on how to do this
would be greatly appreciated.

Todd

Thanks for the suggestion
-----Original Message-----
Hi
see:
http://www.contextures.com/xlautofilter02.html#Count

--
Regards
Frank Kabel
Frankfurt, Germany


Todd F wrote:
When I do an auto filter - sometimes the count of
records
showing appears in the bottom left of excel and some
times it does not.

If I turn off auto calc then it shows up - ? why.

However do to my particular needs - turning off auto
calc
is not a safe option.

So my main question is what can I do to create a
routine
that would display say a combo box giving record count
(something small that can be closed) each time I do a
filter and disaoear when I say show all.

If a floating box is not a good idea I would hesitently
go for putting a cell in row 1 of all my sheets that
gave
me a count of visable records at all times.

ANy thoghts on problem or suggests on how to do this
would be greatly appreciated.

Todd
.