i'm very new to VBA.. and i was wondering how you could program the
following.

lets say you have a single column table and some of the cells have
values and the others dont. maybe 5 out of 20 have names in them.

how could you code a function that will basically relist those names
together?