Create range names with names in column heading

's Computer Specifications

Hi,

Need some help.

I have a sheet that has column headings along row 1. Would like to create
range names with each column heading as the name. The number of rows will
increase.

Any suggestions?

's Computer Specifications

Look for dynarange

http://www.cpearson.com/excel/Download.htm

"NigelVII" wrote:

> Hi,
>
> Need some help.
>
> I have a sheet that has column headings along row 1. Would like to create
> range names with each column heading as the name. The number of rows will
> increase.
>
> Any suggestions?
>

's Computer Specifications

"Office_Novice" wrote:
Thanks for the assistance much appreciated

> Look for dynarange
>
> http://www.cpearson.com/excel/Download.htm
>
> "NigelVII" wrote:
>
> > Hi,
> >
> > Need some help.
> >
> > I have a sheet that has column headings along row 1. Would like to create
> > range names with each column heading as the name. The number of rows will
> > increase.
> >
> > Any suggestions?
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change datasheet column heading names	Darrin	Microsoft Access Form Coding	2	18th Jan 2007 10:31 AM
change column heading names from numbers to alpha characters	=?Utf-8?B?Q2hhbmdpbmcgRXhjZWwgQ29sdW1uIEhlYWRpbmdz	Microsoft Excel Misc	3	14th Sep 2006 02:40 PM
How do you Change Column heading names	=?Utf-8?B?U3V6YW5uZQ==?=	Microsoft Excel Programming	1	11th Oct 2004 11:39 PM
Column heading names	=?Utf-8?B?U2hhd24=?=	Microsoft Excel Misc	3	16th Dec 2003 09:42 PM
Change Column Heading Names	Carl Jackson	Microsoft Excel Misc	2	25th Jul 2003 11:44 PM