Writing an array to a listbox

  • I'm loading rows of data into an array from a filtered range based on what Year is selected from a dropdown box. When I transpose the array into the listbox, the row data is vertical in the first column, second row data is in the second column and so on. I need the array to transpose the row horizontally across the listbox, i.e. 1 row, multiple columns, not stick the row data into one column in the listbox.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!