PC Review


Reply
Thread Tools Rate Thread

Create range names with names in column heading

 
 
NigelVII
Guest
Posts: n/a
 
      25th Jul 2008
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?

 
Reply With Quote
 
 
 
 
Office_Novice
Guest
Posts: n/a
 
      25th Jul 2008
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?
>

 
Reply With Quote
 
NigelVII
Guest
Posts: n/a
 
      29th Jul 2008


"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?
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:34 AM.