I tried to populate selected range from worksheet to listbox.
But notice that the whole thing gone wrong....
Private Sub CommandButton1_Click()
ListBox1.Value = Worksheets("Sheet1").Range("C:D;H:J;L;U:X;AI;AL:AM")
I would like to have only the red range to be in the list box.
can some one help me with this?
really appreciate your help.