Making a large field

M

macfarlane

I need to make a set of 175,000 numbers. Is there a way to avoid pulling the
cells to get this great set of numbers. I would hope that I could just type
first no. & last no. & specify the range? Thank You in Advance.
P.S. The advice re: the dashed no.'s. worked perfectly!
 
C

Chip Pearson

What do you intend to do with these numbers. The maximum number
of rows on a worksheet is 65536, so you can't store them all in a
single column. If you want them in a VBA array, use code like


Dim Arr(1 To 175000) As Long
Dim N As Long
For N = 1 To 175000
Arr(N) = N
Next N



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

message
news:[email protected]...
 
S

SHMUNCY

:) You can type the first number, then highlight the cells you want t
have the series, then click EDIT, Fill, Series. It will even let yo
pick whether to fill in steps of 1, 2, etc... (so you can go 1 2 3 4 o
2 4 6 or whatever separation you want.
 
M

macfarlane

Hi Chip: Thank You for your reply. I am using a software to produce bar
codes. From the bar code program I need to specify a field , such as Excell,
notepad or any no. of different software where I can mate these no.'s. to the
bar code. I do not need to make all of the 175,000 no.'s. at once. I can do
them in any manageable amounts. So the problem is that I am trying to get
away from pulling all these no.'s. in Excell by hand, so that is why your vba
script would be perfect. Is there a way you can modify your script so I can
specify to do a block of no.'s. Thanks again for your trouble.
 
Top