I have a list with cities in USA and Canada. Now I need some VBA code to identify the last row in this list (row 23 in this case), however AFTER the filter has been applied.
So if I filter the list on "USA", the result of the VBA should still be row 23, not row 18.
Can anybody help ? See the enclosed screen capture.
So if I filter the list on "USA", the result of the VBA should still be row 23, not row 18.
Can anybody help ? See the enclosed screen capture.