+ 1 to each cell

  • Thread starter Thread starter Beesht
  • Start date Start date
B

Beesht

I have a number in a column cell which is 102876.
Is there a way to automatically copy this number into other cells i
the column but add 1 at the same time.
So if I have 102876 in the 1st column cell, the 10th one would b
102886.
Thank
 
Several methods for this.

Easiest is to enter 102876 into a cell.

Hover the mouse pointer over the right bottom corner of the cell until the
white cross changes to a small black cross.

RIGHT-click on fill handle(small square lump)and drag down the column.
Release and select "Fill Series"

Next easiest is to enter 102876 in a cell then 102877 in cell below. Select
both these cells and drag/copy down the column using the fill handle.

Then there is Edit>Fill>Series which is the most cumbersome for this
operation.

Gord Dibben Excel MVP
 
Beesht,

This fills A1 10 cells down

Sub test()
With Range("A1")
' .Value = 102876
.AutoFill Range(.Cells(1, 1), .Cells(10, 1)), xlFillSeries
End With
End Sub

Rob
 
Back
Top