put merged and wrapped dynamic cell range contents in list box

    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?


    Thank you.

    Avoid merged cells because they are incompatible with much Excel functionality. I tell students to only merge cells on worksheets that are simple "view-only" reports.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login