VBA to filter based on highlighted cell value in a column the cells sits

Hello All,

I have compiled a little code for a macro to filter based on a highlighted cell value. It is however, for a specific column.

Is there a way to adapt a filter field to be picked up by where the cell is? I mean to insert the cell value into the field that represents the column in which the highlighted cell sits?

Column A is filter field 1 ...

I cannot find anything that will be clear enough to me to understand how I can adapt it to make it happen. Below is the code I used:

Please Login or Register  to view this content.

I need to adapt the part where it says ".AutoFilter Field:=2," to count which column it is to be applied to.

Any ideas appreciated.

Thank you in advance.

Simon

Hi,

change to

Please Login or Register  to view this content.

Incidentally you don't need the .Activate code. .Activate or .Select are rarely needed and just slow things down since VBA has to jump back to the Excel application and return. Not so much a problem here but in loop there is a big time overhead.

Well - if you've got the cell selected:

Please Login or Register  to view this content.

Works beautifully.

Thank you.

I am quite new to the VBA and work with what I have seen already. I keep working at copy and paste method and adjust for the needs.

Thank you for your feedback.

You're welcome and thanks for the rep!