for text to column conversion using vbs code needed

[aakhan2011]

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.

http://speedy.sh/m3ndN/Sheet.xlsm


Thanks in Advance
Regards,
AAK.

 

[VoG]

Cross posted Text to column using VBA

Please read Excelguru Help Site - A message to forum cross posters