Hi All I have a data sheet with a dynamic data rang $A:$A. In some cells the data length is too long so a few cells have been merged, e.g. A1 to D1 and wrapped to avoid cell overlap. This data is displayed in a ListBox. There is a problem however, the wrapped part of the data in the cells is not displayed in the ListBox. Is there a way to round this?