Hi all,
I've got a rather large table that I filter using VBA. My problem is that the table data is often 'off screen', and the filter often appears to show no result.
eg, the last row of the table is currently 7063. scroll to the end of the table, then filter to rows 2000 to 2010, and you must manually scroll them into view.
how can I set the code to show the first visible row of the filtered table automatically?
I have searched for a solution, but it appears I am using the wrong terminology
Any suggestions are appreciated
Thanks
Werafa