Excel filtering and result viewing

[philozelda]

Hi everyone - I created some VBA code in Excel that filters on records based upon a cell value in another sheet. It works just fine as is but one of the annoying things about the filtering process is that once I filter, I do not immediately see the results in the viewing window, I have to scroll upwards a few times before I see the filtered records. My concern for this is that if another user filters on a record and is brought to the sheet where the results are and doesn't immediately see the results, that he will think that there are no records.

My question is, how can I bring the filtered results into view so that I can at least see some records?

[Richard Buttrey]

Hi,

One way would be to move the cursor as the last line of your macro.

e.g.

Please Login or Register  to view this content.

Assuming of course that the filtered sheet is currently the Active sheet. If not Activate the filtered sheet first.

[Winon]

Hello philozelda,

One way is to add this Last line to your Code, just before End Sub:

Please Login or Register  to view this content.

Regards.

[philozelda]

Thank you both for your reply. Both solutions work in that the cursor is placed at the last row after the filter is applied. However, the last row available in the filtered selection is not visible after applying your suggested methods. I believe it has something to do with the freeze pane being applied.

I will try a work around that may include removing the freeze pane, filtering, placing the cursor on the last cell and then reapplying the freeze pane...my hunch is this might solve the problem.

[Richard Buttrey]

Would you upload the workbook and clearly describe what you are filtering and what the Active cell should be after the macro has run.