Dear all,
May i know what's wrong with the code here
I want to display a certain filtered value. Such as this eg, i want all the detail of 5 display. But I could not get any data except the header. Once I remove the "d" in array I can get the answer
Please Login or Register to view this content.
Thank you
Regards,
sorhaishadow
Last edited by sorhaishadow; 11-07-2010 at 05:50 AM. Reason: edit code
Please wrap your code in code tags, before the moderators get you...
Forum rules
3. 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 # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.
Cheers
Why do you want the Loop? What are you filtering for?
Currently your code wil filter for 1,2,3,4,5 & finish displaying 5
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
This is what i meant to do
in the file, i want to get the latest data only as shown at the side
i plan to use filter and get the latest data
what if i have more than 6 data let say 100 or 200
i wish to have a macro on this
thanks in advance
What determines "latest data"?
I don't think AutoFilter will do this?
This might be what you want
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