Hi,
Sheet1 has a button that when clicked shows a message box. I would like to show in the message box values from sheet2 withing range A1:A4. This should be in a format of list with lines ...
line 1 = cell A1
line 2 = cell A2
.
.
This range has dynamic values and sometimes some cells are empty, depening on values from different cells so for example sometimes there are walues in four cells A1,A2,A3,A4 but sometimes there are values in two cells eg A1,A4.
If there are values in A1 and A4 i would like to display them in the message box without empty spaces/lines eg.
line 1 = cell A1
line 2 = cell A4
Sheet1 has a button that when clicked shows a message box. I would like to show in the message box values from sheet2 withing range A1:A4. This should be in a format of list with lines ...
line 1 = cell A1
line 2 = cell A2
.
.
This range has dynamic values and sometimes some cells are empty, depening on values from different cells so for example sometimes there are walues in four cells A1,A2,A3,A4 but sometimes there are values in two cells eg A1,A4.
If there are values in A1 and A4 i would like to display them in the message box without empty spaces/lines eg.
line 1 = cell A1
line 2 = cell A4