List box only showing one column
Posted by Tam on July 05, 2000 7:14 AM
I'm not sure if anybody can help me.
I have a list box, which should contain a list of all Worksheets in the workbook.
This is linked to the "Properties Listfillrange" from [Insert > Name > Define].
The list of sheets is split into 2 Columns (A4:B21).
The problem is that the List box will not show Column B. It does show Column A.
At present the only way around this is to make the list into 1 Column which I don't want it to do or create another List box - again I don't want to do.
Is there a way around this ...please.