Worksheet selection change

Hi All,

I'm currently building a front page for a spreadsheet, the front page makes use of the subtotal function to count only visible cells to give different stats as the data is filtered.

This part is complete, however i'm having a little trouble with the filter, I've made a list of the front page and I want people to be able to select a value from the list and have it auto filter the data accordingly.

I've got it to work sort of, the user has to change the cell, leave it and re-enter it for it to work. In fact it runs the code whenever the cell is entered, I want to run when it's changed or exited.

This is the code

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks in advance, any help is appreciated

Use the Change event, not the SelectionChange event.