VBA to create numerical increment

[jeff p]

Hello.

I have a column that contains a repeating word, within a named range. ("Chapter_Range")
Is it possible to add an incremental value at the end of this word throughout the named range?

As an example, given the name "Chapter"

From this:

Bill
Chapter
John
Robert
Chapter
Mary
Chapter

to this

Bill
Chapter 1
John
Robert
Chapter 2
Mary
Chapter 3


If this is difficult, Having the increment appear in the adjacent cell would also work (although the above request would be preferred)
I will be adding new rows in between, so a VBA script will allow me to manually update via button, when needed.

Thanks for any help

Jeff

.

[Joakim N]

Please Login or Register  to view this content.

[mike7952]

This should work

Please Login or Register  to view this content.

[jeff p]

Thanks for the help!

Both codes worked great.

Unfortunately, It seems I overlooked a flaw in my initial request.

My intention was to have the ability to add new Chapter rows in between, and update their numerical value.


Can the code be modified to also include a previous incremental value at the end

something like Chapter *

Thanks again for the help!

Jeff

[mike7952]

So if you added a new chapter inbetween what number would that chapter be?

Bill
Chapter 1
John
Robert
Chapter 2
Mary
Chapter 3

Bill
Chapter 1
John
Robert
Chapter 'What would this be 2 or 3
Mary
Chapter 2

[shg]

Please Login or Register  to view this content.

[jeff p]

Yes

Thank you SHG


That did it!!

Thanks for all the help on this from everyone!

Jeff