Re: Number range function

From: Bryan Hessey <Bryan.Hessey.1se6qd_1121735121.9373@xxxxxxxxxxxxxxxxxxxxx>
Date: Mon, 18 Jul 2005 19:19:39 -0500

Lets hope for a better solution, but in case:

enter 1, in A1 and hold the CTRLK key and formula drag to 600, this
will number the range for you.
enter Car in B1 and drag to 50, Truck in 51 and drag to 100 etc.
The range can then be used as a range, or named and used as a Named
Range.

(note, to Formula drag, click the small square in the bottom right
corner of the highlight)

--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=21059
View this thread: http://www.excelforum.com/showthread.php?threadid=388198

.

References:
- Number range function
  - From: Sonya T

Prev by Date: Re: How to rename Excel *** with more characters?
Next by Date: Re: why is there 256 columns on excel?
Previous by thread: Number range function
Next by thread: Re: Number range function
Index(es):
- Date
- Thread