ljzmcm
Thread Starter
- Joined
- Apr 28, 2008
- Messages
- 148
Hey all,
I have a custom filter that does:
Greater than or equal too: (date here)
AND
Less than or equal too: (another date)
I recorded the macro, but I want to put the two dates from a cell
this is all wrong, but maybe you can see where I'm going with this:
Sub CustomFilter()
'
' CustomFilter Macro
'
' Keyboard Shortcut: Ctrl+j
'
Selection.AutoFilter Field:=4, Criteria1:=">=(Range("H3").Value)", Operator:=xlAnd _
, Criteria2:="<=(Range("J3").Value)"
End Sub
Should be simple... Any help, please?
I have a custom filter that does:
Greater than or equal too: (date here)
AND
Less than or equal too: (another date)
I recorded the macro, but I want to put the two dates from a cell
this is all wrong, but maybe you can see where I'm going with this:
Sub CustomFilter()
'
' CustomFilter Macro
'
' Keyboard Shortcut: Ctrl+j
'
Selection.AutoFilter Field:=4, Criteria1:=">=(Range("H3").Value)", Operator:=xlAnd _
, Criteria2:="<=(Range("J3").Value)"
End Sub
Should be simple... Any help, please?