Forum Discussion
Automatic change the correct numbering in cells
NikolinoDE
thanks a lot! It worked fine on your sheet, but on my it dont work:
Maybe its because its numbered with 1.1, 1.2 and so on?
You see the empty line between 1.1 and 1.2..
Maybe you can help me here?
Thanks in advance.
Sorry for the late reply, but private obligations were my priority during this time.
Nevertheless, I have not forgotten your request :)).
Enclosed here again with a sub-table in a tenth (0.1) range.
You can insert lines between the numbers where they are automatically divided into tenths.
After inserting the line, please click elsewhere, so the sub-count can also appear.
The only drawback in this VBA code is you have to enter the basic numbering manually in advance. Doing it with VBA might not be that beneficial,
but you probably know better than I what you need for your project :).
I also wish you a lot of fun and success with Excel.