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 23, 2021

BUMP, still got no idea how to realize this.

EberleinHE 

  • 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.

Resources