To convert cells with break lines into multiple rows and columns

Hello,

I have some cells created with line breaks (Alt + Enter) and would like to convert them into multiple rows and columns.

I got below VBA codes (from pommie98's thread, thanks) but only managed to execute for the first column.

Please Login or Register  to view this content.

Could anyone help me on this to extend the action to all the available columns?

Appreciate your kind sharing and assistance in advance.

Cheers,
Leong

Thank you so much millz for your kind assistance and the code works very well without error.

Now i encountered another issue again. Some of my data contain line breaks but some do not (as attached).

I tried with the new code but got an error, and I believe it was because there isn't any char(10) in the cell.

Will VBA be able to identify it and continue the code?

Appreciate your expertise advice and sharing again.

Cheers,
Leong

Hi Johnson,

Many thanks for your sharing but there seemed to be a Run-time error '1004' when it hits the cell without a line break.

Please Login or Register  to view this content.

Could you kindly assist on this?

Cheers,
Leong