Recorded Macro changing date format

[cindywylie]

Hello,

I recorded as simple macro to help with the formatting of a report. The result is changing the format of columns B and H. I need B and H to stay in date format. What am I doing wrong? Thanks

Please Login or Register  to view this content.

[HaHoBe]

Hi, cindywylie,

the line

Please Login or Register  to view this content.

will select the entire range vbetween Column A and Column L (at least on my Excel2013) and will change teh format on Column B.

Please Login or Register  to view this content.

should do better.

Please Login or Register  to view this content.

Ciao,
Holger

[cindywylie]

Thanks HaHoBe! It's exactly what I need. I always learn something here.