Autonumbering

Hi,

How should the macro distinguish between a row inserted between Adrian and Joshua, which presumably should result in '2d' and a line inserted between Sarah and Emilye? What should this contain? also 2d or should the existing number 2? values be renumbered with Emilye now 2c?

Thought I'd mention that you can get cells to auto number by using the ROW() + (any constant) function. This of course always gives you numerics which it sounds like you don't want.

Regards

Regards

if you pre number all rows
then this macro will auto insert and sub number it eg
1
2
3
4
cilck on 3 run macro and you get
1
2
3
3.1
4

Please Login or Register  to view this content.

i know its not letters but it's the best i can do!
i dont know the code to make it only run if cell is in the numbers column tho
"only run this macro if cell is in range a:a" to prevent it being run in the wrong place

Thankyou both of you, you really have been a great help to me.

Thanks again.