I'm using this macro to filter a list which contains words in a selected cell.
With a long list, you can't view what's being filtered.
For this reason, I'm going to the first row, and then using Application.SendKeys ("{DOWN}"), to make sure I can see everything.
The issue is that every time I run the code, the Num Lock keeps turning on and off.
Is there a way to stop?
Please Login or Register to view this content.
Save numlock status before https://www.mrexcel.com/board/thread...-state.677200/
and return back after
Thanks, I'll look into this.
If you had to use send keys would it not be END + DOWN?
Alternative to send keys
Please Login or Register to view this content.
Andy, this looks good considering the issues with SendKeys.
But is there a way to go the the first row after the header row A, rather than the last. The reason is that if the list is longer than the page view, you can't see the first visible row.
Sorry I thought you wanted to go to the end of the list.
Would the first unfiltered row not be immediately below A1 and therefore in view?
The application.goto method takes an argument which you can set to TRUE which will make A1 visible
Or you code use this to get second visible row
Please Login or Register to view this content.
Actually for a long list, the first unfiltered row is typically not in view.
For example, if I have a list of 1000 entries and only 3 of those still remain after the filter, then most of the time, I don't see anything. It depends on where in the sheet I am. This may be because I have the freeze pane setting on.
EDIT: After viewing the above post, it works now. Thanks for resolving this.
Last edited by Un-Do Re-Do; 11-13-2020 at 04:57 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks