Display Columns in Listbox only if cells are not empty in a selected Range

[desantech]

Hello

I didnt search for it yet a lot, but till now I couldnt find anything. My question is:
1. I have a lot of rows with data in 10 different columns (or more), like width, height, color etc but not all cells are filled with info
2. I would like to display all those columns in a listbox that have cell value in a range:
(if my selected range is blue text, then all those yellow columns are displayed even if in range there are some empty cells)

D	d1	OD	L	l1	B	b1	b2	H	h1	h2	R	alpha	t1	W	V	G	CHF pro Stk.
224	153					35.5		60								1740	2'020.00
274	178					48		60								2440	2'190.00
			50		67			92	45							430	496.00
			100		67			92	45							860	820.00
			246	140.6	67			92	45		156.6	90				1580	2'060.00
			45		45			45								50	194.00

so it would look like this:

			L	l1	B			H	h1		R	alpha				G	CHF pro Stk.
			50		67			92	45							430	496.00
			100		67			92	45							860	820.00
			246	140.6	67			92	45		156.6	90				1580	2'060.00

Thanks a lot

Kind regards

[desantech]

Well the question is: (its about a listbox on a userform)

1. I have a lot of rows with data in 10 different columns (or more), like width, height, color etc but not all cells are filled with info in the columns
   
2. I would like to display all those columns in a listbox that have a cell value in a selected range, like selected range is A110, but C1-C10 has no value, so that wont be displayed, but only D10 has a value, so whole D1-D10 will be shown as column in listbox: (if my selected range is blue text, then all those yellow columns are displayed even if in range there are some empty cells)