If the cell(1,1) has data of several lines
eg:
Hello World
Hello World
Hello World
Hello World
Hello World

How can I split this data into several rows using VBA?

The steps to do the same manually are
1. Select the data in cell(1,1)
2. Cut it
3. select cell(2,1) and select back cell(1,1)( to resize the cell1)
4. Paste the data in the buffer and excel automatically pastes each
line into a different row.

How do I perform the same using VBA, if I try to record the actions
described above , excel is not recording any statements for steps 1 and
2.

I appreciate any help..


---
Message posted from http://www.ExcelForum.com/