Name Data Column To First Row in Column

[Mean_Mode]

Hey,

I'm trying to name three workbooks worth of data to the varaible that is in the first row of each column. The data deminsions can change, rows and in number of colums columns so I can't hardcode that.

I'm pretty new to Excel VBA so any help would be much appreciated. Data attached is an example of what I am trying to do the first row {Pizza, Tacos, Pasta, Burgers} would be the new named ranges. The Pizza range would countain {sauce, meat cheese}

Thanks!

Pizza	Tacos	Pasta	Burgers
Sauce	Beef	Sauce	Cheese
Meat	Cheese	cheese	Onion
Cheese			Pickles

<TBODY>
</TBODY>

 

[ParamRay]

.
.

Follow these steps:

(1) Select cells A1:D4 (i.e. from Pizza to Pickles);
(2) Execute a Go To Special:

Home --> Editing --> Find & Select --> Go To Special;

(3) In the Go To Special dialog box, choose Constants (Text) and click OK;
(4) Execute a Create Names from Selection:

Formulas --> Defined Names --> Create from Selection;

(5) In the Create Names from Selection dialog box, choose Top row and click OK.