R
Ronald Janssen
Hi,
I use a Excel for a small database (less than 1000 records). One of my
columns contains dates. Using Autofilter I can select a date and get the
records containing this date.
My problem starts with Autofilter as part of a macro/vba sub
Using the same filter criteria but this time automated the corresponding
number of records are zero !
If I then check my database manually:
The Autofilter button for the date column is colored blue as it should be.
If I click on that button I notice that the correct date in the list is
selected/highlighted but it requires a "manual" click to actually get the
data visible.
This "problem" occurs both in 97 as well as in XP.
The help file does not "help" nor have I found an answer in Microsoft's KB.
Anyone familiar with this phenomena and its solution ?
Thanks for your reply
Ronald
I use a Excel for a small database (less than 1000 records). One of my
columns contains dates. Using Autofilter I can select a date and get the
records containing this date.
My problem starts with Autofilter as part of a macro/vba sub
Using the same filter criteria but this time automated the corresponding
number of records are zero !
If I then check my database manually:
The Autofilter button for the date column is colored blue as it should be.
If I click on that button I notice that the correct date in the list is
selected/highlighted but it requires a "manual" click to actually get the
data visible.
This "problem" occurs both in 97 as well as in XP.
The help file does not "help" nor have I found an answer in Microsoft's KB.
Anyone familiar with this phenomena and its solution ?
Thanks for your reply
Ronald