VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

Hi, vijay21,

the long for a date in Format dd/mm/yyyy should be equal to that of mm/dd/yyyy as long as Excel recognises the input as a Date. So maybe use the CLng-conversion for your search or apply the Autofilter (which in VBA would need a long value for putting up any result).

Ciao,
Holger