Auto number code

I Found This code To Make Auto Numbring but I don't know how can I change the code to change the Starting Cell & How can I choose the column & row In this code ?

Please Login or Register  to view this content.

Big Thank's for you My dear

But I still don't know what i Have To change to choose the starting cell ?

I knew Now what I should change to change the column

but how can i choose the starting cell ??

for example lets make the auto numbering In coulumn " c " But Start Numbring If I write In " c 10 " and Below

Thanks again

This 2 is what you need to change. If you set it to 9, a 0 will be put in C9 a 1 in C10, etc.
"=IF(COUNTA(RC[1]:RC[1])=1,COUNTA(R2C[1]:RC[1]),"""")"

The routine that you found and posted is not very generic and is difficult to change. A detailed explaination of what you want might result in a routine tailored to your specific needs.

i still have problem

please see the attachment .. i change the starting cell , but now tray to write above B5 and see

I wrote a different routine. The starting cell is easier to modify. There are two versions.
The current version puts a number in the cell rather than a formula. This will improve the speed of your spreadsheet, but will not react to inserting or deleting rows.
The line that is currently commented out, puts a formula in the cell, which will react to inserting or deleting rows, but slows the spreadsheet a bit.

Please Login or Register  to view this content.