Hi,
I have a multi-select listbox that is populated by the description column (B) value for all rows of data on a particular spreadsheet. The idea is that people can from this select the rows they are interesed in and these are pasted into word as a table.
Currently the user can either:
The latter doesn't link them because if the rows are non-contiguous then a linked table would contain the interveening cells. However it is probably that in most cases the rows that are selected will be contiguous and therefore could easily be pasted as linked tables. The question is: is there an easy way to tell if only contiguous rows in a listbox have been selected?
- Select All Rows and the data will be pasted as a linked table
- Select any rows they want and the data is pasted as a non-linked table.
I imagine I would be able to do something with checking the difference between two consecutive selected list indices, but am wondering is there is a better way.
Hope that makes sense. Robyn