Hi, I have header type data in a row over several columns. I need to use a
list box to delete the data from the whole column when I select the header
from a list box. I've done this with list items from 1 column, multiple rows
where I name the region then use rowsource to populate the list box. How
would I do that same thing with elements horizontally across the page rather
than vertically down the page? I can setup the list box by placing references
to the data in rows on another sheet but that will setup the list box only, I
wouldn't know how to select the correct column in that case. Any ideas would
be appreciated.

Thanks,
John

I figured it out, thanks anyway.

John

"johnrb7865" wrote:

Hi, I have header type data in a row over several columns. I need to use a
list box to delete the data from the whole column when I select the header
from a list box. I've done this with list items from 1 column, multiple rows
where I name the region then use rowsource to populate the list box. How
would I do that same thing with elements horizontally across the page rather
than vertically down the page? I can setup the list box by placing references
to the data in rows on another sheet but that will setup the list box only, I
wouldn't know how to select the correct column in that case. Any ideas would
be appreciated.

Thanks,
John