Set Const Delimiter as line break (non-string)

Hi,

I'm using the below code to break some cells into rows. Each cell contains multiple lines (using Alt+Enter), which I want to split out into individual rows. The VBA code works well, however I cannot work out how to change the Const Delimiter value on line 3, to represent a "line break" as it is not a string value. Can this be done? Or should I simply add a string delimiter to the end of each row. This would be a pain, but manageable.

Please Login or Register  to view this content.