Populating selected range to listbox

[cupid800429]

Hi,

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")
End Sub

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.

regards
VJ