Date format changes after macro run

Hi All

I have a workbook where I import over a thousand rows of data into that I need to filter through. The data I import has the correct date format that I need ( dd/mm/yyyy ). 2 of the columns are purely dates in the worksheet but when I run my macro which hides columns and adds cond format etc to save time it throws the date into mm/dd/yyyy


Is there any way I can change this. Look forward to a top draw response as always from this forum


Miff3436

Hi

Thanks to the speedy respone. This probably sounds daft but where do i actually put this code ?

i have adapted it to the columns i need and tried putting it in every event that would start before my macro runs...

Thanks Miff3436

Sorry it was just me been a bit slow ! Yes that does work I forgot to change the column letter



Thanks again
Miff3436