Re: When I filter data, sometimes I do not get row count retrived
From: SOS (SOS.1b8yd9_at_excelforum-nospam.com)
Date: 08/19/04
- Next message: Jenny: "How do I use the same BeforeClose event on multiple workbooks"
- Previous message: Norman Jones: "Re: When I filter data, sometimes I do not get row count retrived"
- In reply to: gansh_k: "When I filter data, sometimes I do not get row count retrived"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 19 Aug 2004 12:45:11 -0500
If your worksheet has any formulae on it they automatically calculate
after filtering thereby suppressing the message "3 of 25 rows". I
suggest clicking Tools/Options/Calculation and switching it to manual
for the timebeing and your message will appear.
HTH
Seamus
--- Message posted from http://www.ExcelForum.com/
- Next message: Jenny: "How do I use the same BeforeClose event on multiple workbooks"
- Previous message: Norman Jones: "Re: When I filter data, sometimes I do not get row count retrived"
- In reply to: gansh_k: "When I filter data, sometimes I do not get row count retrived"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
