columns/rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top