Excel Custom Date Filter with CELL

New Contributor

I am trying to filter a column based on dates, custom date value present in some other sheet say Sheet1 Cell L5. But something is wrong  and I am unable to get it right.

Macro when I manually wrote the value in filter option generated is:


Sub CustomDateFilter()
' CustomDateFilter Macro

ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 6
ActiveSheet.Range("$A$1:$CU$1077").AutoFilter Field:=21, Criteria1:= _
">='Sheet1!L[5]'", Operator:=xlAnd
End Sub


I want the custom value to be cell Sheet1 Cel L5 but I am unable to do this.

can somebody guide ?

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies