S
Stefi
Hi,
Did anybody meet with this problem:
Applying Autofilter on a date field in a macro results in no matching rows
no matter what were the field values and the criteria. Breaking the macro
just after the Autofilter statement and in interactive mode having a look at
the filter setting of the column in question it shows the intended values .
Making NO changes and pushing the OK button results in correct filtering: the
rows matching the criteria are shown.
Any idea for achieving this directly from the macro?
Stefi
Did anybody meet with this problem:
Applying Autofilter on a date field in a macro results in no matching rows
no matter what were the field values and the criteria. Breaking the macro
just after the Autofilter statement and in interactive mode having a look at
the filter setting of the column in question it shows the intended values .
Making NO changes and pushing the OK button results in correct filtering: the
rows matching the criteria are shown.
Any idea for achieving this directly from the macro?
Stefi