Date formatting VBA

[aganesan99]

Hello,

I recorded a macro for formatting text value 31-09-14 as date format using "Text to Column" option. The code is as follows:

Please Login or Register  to view this content.

I couldnot change the "Destination:=Range("A4")" as it is showing error. I need to change it as whatever cells I select it should take that as Destination and change the format.

Any help appreciated.

Thanks,
aganesan99

[Jack7774]

Please Login or Register  to view this content.