find next available number

[mduntley]

I need to find a number that is not existing. My document is huge and I want to put in a number and it will give me a new code that isn't being used

Column A is the section that the existing code is on

B2 is where I want to put in a number.

c3 is where I want to see what is the next available number I can use.

 

[mduntley]

Your very close, Replace 11 with 17 !!

If f = [B][COLOR=#FF0000]17 [/COLOR][/B]Then Exit Sub

Thank you for your help+

 

[MickG]

You're welcome