I have a spreadsheet that I have to enter xxxxx digits into the first
column/first row. I was wondering if there was a way to set the spreadsheet
to complete the xxxx1, xxxx2 xxxx3 in the rows beneath automatically?

If no is it because excel does not know what numbers would come next?

One way. You could also have a worksheet_change event where it would be
entirely automatic.

Sub addonto()
For i = 2 To 4
Cells(i, 1) = Cells(i - 1, 1) + 1
Next i
End Sub

--
Don Guillett
SalesAid Software

"teddkilroy" wrote in message
...
I have a spreadsheet that I have to enter xxxxx digits into the first
column/first row. I was wondering if there was a way to set the
spreadsheet
to complete the xxxx1, xxxx2 xxxx3 in the rows beneath automatically?

If no is it because excel does not know what numbers would come next?

Depends on what you mean by automatic.

You could enter
xxxx1
in A1, and
xxxx2
in A2, and select *both* cells and click on the "fill handle" (little black
square in the lower right corner of selection), and drag down to copy as far
as you need.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"teddkilroy" wrote in message
...
I have a spreadsheet that I have to enter xxxxx digits into the first
column/first row. I was wondering if there was a way to set the
spreadsheet
to complete the xxxx1, xxxx2 xxxx3 in the rows beneath automatically?

If no is it because excel does not know what numbers would come next?