Small vba code needed - for text to column conversion

Hi All,


Need vba code to convert 'Mod' sheet from text to column in 'Row Data' sheet by click of 'Text to Column' button.
The data selected in 'Mod' sheet should be converted to column done manually by clicking 'Text to Column' -> 'Delimited' -> 'Space'


Sheet attached.

View attachment Sheet.xlsm


Thanks in Advance
Regards,
AAK.

crossposting here and http://www.excelforum.com/excel-programming-vba-macros/1005497-text-to-column-using-vba.html