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.
I´m getting #NAME? in all the cell (the range is right) How shall i do?
Please Login or Register to view this content.