magelan
03-11-2013, 09:56 AM
Hi All,
difficult question time.
I want to make a listbox and have the column headings display A, B, C, D, E, etc. The true column headers.
I've figured the way to do this is to copy the data and insert A, B, C, D, E etc, above it. However, I do -not- want to make a new worksheet and physically copy it. This feels clumsy and archaic.
How can I go about making a range source in virtual space so that I can avoid storing my data on a worksheet just to get some proper column headings on it? Never mind the fact that setting column headings should not force you to base it on "the row above your range source".
difficult question time.
I want to make a listbox and have the column headings display A, B, C, D, E, etc. The true column headers.
I've figured the way to do this is to copy the data and insert A, B, C, D, E etc, above it. However, I do -not- want to make a new worksheet and physically copy it. This feels clumsy and archaic.
How can I go about making a range source in virtual space so that I can avoid storing my data on a worksheet just to get some proper column headings on it? Never mind the fact that setting column headings should not force you to base it on "the row above your range source".