Hi all,

I have a ListBox (named ListBoxManad) containing all the months. I want in col A to have one word, lets say "bills" to be merged together with chosen value from listbox; like this: "bills May" (if I have chosen may in listbox, and without the "-characters) I want that in col A as long as there are some kind of values in col L.

I use this code right now but concatenate dosent seem to work with ListBoxManad.value. 

Range("A2:A" & Range("L65536").End(xlUp).Row).Value = "=CONCATENATE(""Bills"","" "",ListBoxManad.Value)"
I´m getting #NAME? in all the cell (the range is right) How shall i do?

/Masun