how to get filtered details (Filtered by Cells color, Font color) in VBA
Dear Coding experts,
In Excel, I can filter any column by font color or cell color. Like- In below picture, I have filtered a column by font color. Now I am trying to write a VBA code to find out which column is filtered by which method (Filter by cell color or Filter by Font color).
can you please help how I can get the details?
filtered column.png
Last edited by mohsin.bipu; 11-07-2022 at 08:54 AM.
Does this work for you?
Please Login or Register to view this content.
hello Bytemarks, Thanks for your code. your code is give me whether any range is filtered by font color or Cell background and Column Name (like C column, D column). But this is not giving me by which color, sheet is filtered. I need the color name also. Like I need to get RGB value/color name also. Please help on this. Thanks in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks