Convert Text Date Range to Date

[animas]

I need to convert a range that may consists Text Date or Date into Date using vba. User will select a range and will run the macro.

How to do this?

 

[schielrn]

Have a look at using Data-->Text to Columns

If you want it in vba code, then just record the macro using data text to columns and modify that code, but if they can run a macro they should be able to just use text to columns.

Hope that helps.