N
Nikki
D/All
Firstly can I apologise in advance as I know this is a long protracted
subject as I have read loads of postings however I haven't found the
answer... and hope that there is one!
I'm basically asking the user to input two dates (dd/mm/yyyy) via two
separate InputBox commands to autofilter a report from a start date to
an end date. The column being filtered has dates in the format
dd/mm/yyyy.
If the user inputs a date that cannot be misread as American eg
31/09/2003 then the filter keeps the correct date but if the date is
input as 12/10/2003 the filter sees it as 10/12/2003.
I'm using English regional settings with short dates of dd/mm/yyyy
however this macro needs to work on other PCs which may not
necessarily have the correct setting.
How do I get the InputBox variable (dd/mm/yyyy) to stay the same in
the autofilter?
[XL2K, Win2K]
Many thanks
Nikki
Firstly can I apologise in advance as I know this is a long protracted
subject as I have read loads of postings however I haven't found the
answer... and hope that there is one!
I'm basically asking the user to input two dates (dd/mm/yyyy) via two
separate InputBox commands to autofilter a report from a start date to
an end date. The column being filtered has dates in the format
dd/mm/yyyy.
If the user inputs a date that cannot be misread as American eg
31/09/2003 then the filter keeps the correct date but if the date is
input as 12/10/2003 the filter sees it as 10/12/2003.
I'm using English regional settings with short dates of dd/mm/yyyy
however this macro needs to work on other PCs which may not
necessarily have the correct setting.
How do I get the InputBox variable (dd/mm/yyyy) to stay the same in
the autofilter?
[XL2K, Win2K]
Many thanks
Nikki