Newer Excel programs (I am using 2013) have very useful filters. I would like to know how to access the current filter setting's StartDate and EndDate in vba code.(Sorry for cross posting in SO but its not likely to get anywhere after almost a month of having been asked)
So there are a bunch of constants like <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">xlFilterThisWeekthat
</code>that are exposed, but I'm more interested in getting at the actual dates that Excel is calculating as opposed to replicating that myself. Is this possible?
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: inherit;">Sub spud()
ActiveSheet.ListObjects("Table2").Range.AutoFilter Field:=1, Criteria1:= _
xlFilterThisWeek, Operator:=xlFilterDynamic
End Sub
</code>
So there are a bunch of constants like <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">xlFilterThisWeekthat
</code>that are exposed, but I'm more interested in getting at the actual dates that Excel is calculating as opposed to replicating that myself. Is this possible?
<code style="margin: 0px; padding: 0px; border: 0px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: inherit;">Sub spud()
ActiveSheet.ListObjects("Table2").Range.AutoFilter Field:=1, Criteria1:= _
xlFilterThisWeek, Operator:=xlFilterDynamic
End Sub
</code>