getting row and coloumn info from listfillrange
 

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...... :(


--
michdan
------------------------------------------------------------------------
michdan's Profile: http://www.excelforum.com/member.php...o&userid=25218
View this thread: http://www.excelforum.com/showthread...hreadid=387462