My current VBA code is:
It works fine unless the ActiveCell is a Date ... then NO results are returned.![]()
Sub Filter_by_Active_Cell() Dim ColNum As Integer ColNum = ActiveCell.Column - (ActiveCell.CurrentRegion.Column - 1) Selection.AutoFilter Field:=ColNum, Criteria1:=ActiveCell End Sub
How can I modify this code so that whether the Activecell is an amount, text, date, etc, it will filter properly?
Your help will be appreciated.
Thank you.
Bookmarks