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

Resources