Insert & Sequentially Number Column

Hi,

instead of Cells(2, 1).End(xlDown)

use Cells(Rows.Count, 1).End(xlUp)

to refer to the last cell containing data in column A.

Regards,
Ingolf

Hi,
If I record:
Columns("A:A").Select
Selection.Insert Shift:=xlToRight
Range("A1").Select
ActiveCell.FormulaR1C1 = "Avnet Key"
Range("A2").Select
ActiveCell.FormulaR1C1 = "1"
Range("A3").Select
ActiveCell.FormulaR1C1 = "2"
Range("A2:A3").Select

Where do I put your code?

Thanks
--
Thanks!

Dee


"Ingolf" wrote:

> Hi,
>
> instead of Cells(2, 1).End(xlDown)
>
> use Cells(Rows.Count, 1).End(xlUp)
>
> to refer to the last cell containing data in column A.
>
> Regards,
> Ingolf
>
>