Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advance Filter
Hello group,
I am using Excel 97 with Win95. I use VBA to filter some of the data. When I format the range with date (mm/dd/yy) the macro work fine but when I format with date and time (dd/mm/yy hh:mm) then it did not work. Anyway to work around this problem, I prefer to have date and time in one cell if possible. Thank you for your time. Long |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advance Filter
In VBA you generally need to use the date serial or work with US formatted
dates. -- Regards, Tom Ogilvy smi wrote in message ... Hello group, I am using Excel 97 with Win95. I use VBA to filter some of the data. When I format the range with date (mm/dd/yy) the macro work fine but when I format with date and time (dd/mm/yy hh:mm) then it did not work. Anyway to work around this problem, I prefer to have date and time in one cell if possible. Thank you for your time. Long |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
advance filter | Excel Discussion (Misc queries) | |||
Advance Filter | Excel Worksheet Functions | |||
Advance Filter | Excel Discussion (Misc queries) | |||
Advance Filter | Excel Discussion (Misc queries) | |||
about advance filter | New Users to Excel |