hi

I have a listbox that takes the data from another worksheet.

I have to be able to add coloumns to this worksheet and therefore I have to update the listbox1.listcount.

The listbox1.listfillrange will automatically be updated if I add a row or add a coloumn to this worksheet.

But how can I get the info about how many coloumns that are in the list now ??

The listbox1.listcount property isn't updated automatically......