Auto numbering VBA code

[sangeeta25]

Hi everyone!

I am currently working on a spreadsheet and I am facing some difficulties in regards to auto numbering.

Basically i have a column which contains consecutive numbers, i.e. cell G9 contains the value 126, G10= 127, G11= 128, G12= 129....etc... so what i would like to do is.. when someone inserts a new row, then cell G13 for instance should automatically contain the text/value 130, and then G14= 131 etc....thus every next G"" cell should only contain the number above the previous G"" cell. Thus i believe that i need a code which i cannot quite figure out.

Could anyone please help me with this?

Thanks!!!

Sangeeta

 

[Smitty]

Welcome to the Board!

If you convert your data range to a table, then you can use a formula like =ROW()-1 to autonumber column G. As new rows are added the formula will autofill.

HTH,