Add sequential numbers between values, within a Range.

  • I have a named Range called "SEQ" in Column C that spans about 4000 rows.
    Within this Range are various markers. "x"
    New rows are routinely added.
    I'm in need of a VBA script that will add a numerical sequence between these markers, in this named Range.


    -- from this:


    C
    x




    x


    x





    x


    ---to this.
    C
    x
    1
    2
    3
    x
    1
    x
    1
    2
    3
    4
    x

    Many thanks!

  • Try this

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!