Enter in Cell the Column Letter that is Filtered

[Michael Fowler]

Is there a way that you can automate into a cell (either by formula or macro) the Column Letter that is filtered ?

Example : Column D is filtered, so as a result I want "D" or the Column Heading Name automatically entered into a cell.

 

[eiloken]

Hello again. I've got your code above as a module in the sheet that needs refreshing. I've also got =DetectFilter() in a cell outside the range being filtered. But it's still not automatically refreshing when I select an auto-filter.

it not refresh after filtered, if refresh after you select another cell of that worksheet, the code will need to place at worksheet that has "=DetectFilter()" formula

 

[Michael Fowler]

it not refresh after filtered, if refresh after you select another cell of that worksheet, the code will need to place at worksheet that has "=DetectFilter()" formula

Yes, I think I've got all that. I've got this formula outside the filter range in a sheet named "Data" ... =Detect_Filter() and I've got this in the VBA code ...