populating a listbox with dynamic array

Hi, im using this code now trying to populate my listbox without success. Brief background on what this code does:
when users make a selection in combobox2, it checks column D of worksheet "Lookup" and finds rows that match the selection. The corresponding value in column B is transferred as header to a worksheet in different columns that matches the combobox selection. It then pulls data from sheets that matches the header and populates in the rows below the header. Now after all these are populated, im trying to transfer these data into a listbox. Column number may exceed 10, that's why i can't use .Additem function. The number of rows and columns to populate in the listbox may differ based on combobox2 selection, that's why i need both rows and columns to be dynamic. Can anyone please help me with this?

sorry for all the unused variables listed as i was trying alot of different methods prior to posting

Please Login or Register  to view this content.

Hi Alpha Frog, yes that's the part of the code that is not working. I tried changing to what you suggested, but the listbox is only populating column A of the worksheet. How do i change it so that it will start populating from column B down to the last used column?

Thank you so much!!