I think you'd need code:

Take a look at application.getcustomlistcontents in the help and you'll see that
you can acces it directly.

For example:

Option Explicit
Sub testme()
Dim listArray As Variant
Dim iCol As Long
Dim wks As Worksheet

Set wks = Worksheets.Add

For iCol = 1 To Application.CustomListCount
listArray = Application.GetCustomListContents(iCol)
wks.Cells(1, iCol).Resize(UBound(listArray) _
- LBound(listArray) + 1, 1).Value _
= Application.Transpose(listArray)
Next iCol

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Anthony wrote:

hi,
have set up a custom list toolsoptionscustom listsimport list from cells.
how do i now insert this list in a column on a spreadsheet?
any help would be great
thanks
Anthony

--

Dave Peterson