Code need to be expanded and running faster

Hi I have below code it change the format to text and the date like this DDMMYY. It works ok.
But if there is blanks or if I set the range so it cover after blanks, it run endless. If there is no blanks and the range is with date it run fast.
SO this is one of the problems, But also I need it to be expanded so it cover all these columns.
k2:K10000
N2:N10000
AR2:AR10000
And in top of that I need it to be able to do this in below sheets.
spain,italy,austria,portugal,france,belgium,netherlands
So I need to be changed for sure. And also the problem with the speed need to be fixed first.

Please have a look I have attached a sheet to work with.

P.s in the test sheet I did not change the sheet name to spain etc. but please do if you want to play with that.

Thanks in advance

Abjac

The code.

Please Login or Register  to view this content.

Do not hard coded range, instead use count.

Please Login or Register  to view this content.

Hi AB33 and thanks for your answer. That did the trick with the speed and empty cells for sure.
Thanks allot for that
How can the code be changed to include. The 3 columns
k2:K ,N2:N, AR2:AR and take the 7 named sheets.spain,italy,austria,portugal,france,belgium,netherlands

Thanks in advance

Sincerely
Abjac

HI AB33 WOW Just checked it and it really works really great. So thanks allot just fantastic code. I managed to get it to work with below 2 codes and one column more. But yours code so wow. Thanks allot

My clumsy but working 2 codes.

Please Login or Register  to view this content.