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!