Forum Discussion

EberleinHE's avatar
EberleinHE
Copper Contributor
Nov 18, 2021

Automatic change the correct numbering in cells

Hello,   thanks for the fast and easy problem solving on my last request. Here i got another problem, where i cant find any solution:             When i insert a new cell between 2.5 ...
excel
Formulas and Functions
Macros and VBA
EberleinHE's avatar
EberleinHE
Copper Contributor
Nov 25, 2021
Hi NikolinoDE,

thanks! But it doesnt work. If i change 3 for example with 4, it switches automaticly back to 3.
Also, the numbers dont start with the exact row like in your sheet.

Do you have any other ideas?

Thanks in advance..
  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Nov 28, 2021
    The automatic numbering only works when you insert lines, not when you manually intervene between the numbering.
    If you insert new lines between the numbering, you will see that the additional lines are automatically inserted in the order and the numbering is shifted.

    Hope that you can understand the inserted VBA code with this information.

    Thank you for your understanding and patience
    • EberleinHE's avatar
      EberleinHE
      Copper Contributor
      Nov 28, 2021

      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.

      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor
        Dec 03, 2021

        EberleinHE 

        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.

Resources