Dear Sunil,
You can use the following UDF:
This Custom Function can be used to highlight them. Enter the following code
in a standard module. (Alt + F11, then Insert, Module from the top menu)
Function FilterOn(myCell As Range) As Boolean
On Error Resume Next
With
Hi Sunil,
Attached file might help. I found it on net.
Cheers to the original programmer.
Best regards,
AJ
On Sat, Nov 21, 2009 at 2:27 PM, SSG sunilsga...@gmail.com wrote:
Sir,
Many times, it happens that we apply a filter on one or more columns.
During the course of our handling and
Sir,
Many times, it happens that we apply a filter on one or more columns.
During the course of our handling and scrolling left-to-right or
otherwise, we often forget which columns have been filtered.
Is there a good and efficient and clear way of telling or highlighting
FILTER columns, e.g., if