+ 1 to each cell
 

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

--
Message posted from http://www.ExcelForum.com

+ 1 to each cell
 

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 EditFillSeries which is the most cumbersome for this
operation.

Gord Dibben Excel MVP

On Fri, 23 Jan 2004 19:37:54 -0600, Beesht
wrote:

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


---
Message posted from http://www.ExcelForum.com/

+ 1 to each cell
 

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


"Beesht " wrote in message
...
I have a number in a column cell which is 102876.
Is there a way to automatically copy this number into other cells in
the column but add 1 at the same time.
So if I have 102876 in the 1st column cell, the 10th one would be
102886.
Thanks


---
Message posted from http://www.ExcelForum.com/

+ 1 to each cell
 

Thanks for your help

--
Message posted from http://www.ExcelForum.com