VBA Date Format
Hi Aidan
Didn't work suspect its because of time element. The idea is that the
variable must check the condition excluding the time element. ie if
24/May/2006 < 24/May/2006 then do xyz. But i suspect because the cells
have been formated with time the variable is checking with the time
element ie 24/05/2006 15:45:23 < 24/05/2006 16:00:10 and therefore
jumping to abc instead of xyz.
any help appreciated. Thks and Rgds KZ
|