Hello Everybody,
The code attached with the workbook works fine, i just want this code to be consider for the visible cells only. For the sake of example workbook is attached with the thread. Here in the comments in the worksheet, if one delete all the comments then this code works fine.
Last edited by kate.middleton1; 10-08-2012 at 12:17 PM.
Hello kate.middleton1,
On Sheet1 in Column 2, Click on the "Filter arrow" > Deselect All > Select Student Number, and Click on O.K.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hello,
I didn't get your point.
On Sheet1 in Column 2, Click on the "Filter arrow" which is the Grey Down Arrow in Column2, Row3. On the Filter screen that appears, clear the check in Select All. Then Select a Student Number - (Use 654), and then at the bottom of the Filter screen Click on O.K.
The information will be displayed exactly according to your desired outcome as shown in Sheet 3
Actually i want to implement it using vba Code, only those cells must be compared which are filtered.
The way I see it, is that the Code already does just that - to a point - whereafter human interface is needed to refine the filter/s to the desired result.
I honestly don't think it would be possible to Code for all the possible permutations of filters a user may require.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks