Filter records using excel 2007 macros not working
I had to filter set of records and return the count. I tried recording the steps using macro recorder and wrote this piece of function.
Not sure what is wrong. Checked the mandatory things like macro security enabled...
Please Login or Register to view this content.
Any help will be appreciated
Moderators note: code tags added for you - this time
Last edited by FDibbins; 01-19-2013 at 05:55 PM.
Ho soundar, and welcome to the forum
Please note that whe you post VBA code, you are required to use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
I have added them for you this time, please use them next time
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi soundar.vit
What is "Chennai"? It's not defined in your code.
Here's a code snippet to count the visible cells in a Filtered RangePlease Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Or without filtering.
Please Login or Register to view this content.
Kind regards, Harry.
Hi jaslake, thanks for your reply. "Chennai" is the filter parameter. Basically, the macro should do the following.
1)Select another sheet i.e "Contact Details"
2) Clear any filter already there in the sheet
3) Get the range having data
4) Apply new filter for location i.e "Chennai" and column index = 10
5) return the resulting row count
Hi Harry, Thanks for your time..
tried ur function too. Getting an error when accessing the object .Columns(10,"Chennai")
Checked using immediate window
?Sheets("Contact Details").UsedRange.Address returns $A$1:$U$92
But, executing the below snippet throws Run time error 1004- Application -defined or Object defined error
?Sheets("Contact Details").UsedRange.Columns(1,10)
You are missing a closing ")". Copy the code of the forum.Originally Posted by soundar.vit
Or if you are allways looking in columns(10) for "Chennai"?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks