Hi,
In excel 2003 the filter will show only the first 1000 results hence you are not able to view data beyond 1000(but custom filters will work), where as this problem will not be there in excel 2007, Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Prashant Pednekar Sent: 08 September 2009 AM 11:57 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Filter problem Dear all Thanks for the knowlege enrichment of excel by you all... I am facing problem with Filter. While filtering data I am not able to see the data after specific cell. See the filter range.bmp. In the file i am not able to see the rows after value 3264.( see Book master 2. worksheet in filter problem file) But If I am using custom filter for values above 3260 and the rows all rows after 3260 can be views.( see Book master 3. worksheet in filter problem file) My problem How I can see the values after 3264 in book master 2 worksheet ? Thanks for your time . Waiting for your reply. Prashant. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it. --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
