Hi guys,

I'm using the following code to combine the 6 cells below any cell with a top border on my worksheets into the top border cell using the Chr(10) feature of excel - All other cells which now contain no data are hidden.
I want to have a way of reversing this action, thereby taking the contents of each visible cell with a top border, and splitting it according to its contents. Where a Chr(10) character is used in the cell contents, place the value in the cell below. Complete for all cells on WS

Below is the code im using to combine.

Regards 

Please Login or Register  to view this content.