VB Code Navigating to Next Available Worksheet in Range

[Randy11]

Am looking for assistance with some VBA code.

Have a range name set up that is Cell B2 on Sheet1:Sheet10. Range is Named "UnitNumber"

Have placed button control on a menu worksheet that would like to open a InputBox("Key in Unit Number")

If unit number has already been keyed in B2 in range Sheet1:Sheet10 Cell B2, jump to that sheet and land in cell B5.

If unit number has not yet been entered into range Sheet1:Sheet10 Cell B2, then go to next sheet in range with nothing in Cell B2 and place unit number keyed in UnputBox in Cell B2, then move to cell B5.

Currently have code for navigating that is based on Worksheet name and this will not work for what I am trying to achieve.

Your assistance Appreciated....

 

[Randy11]

Have verified no leading or following 0's in any of the B2 cells. B2 cells are all formated as General. Ideas?

 

[SkipVought]

The code works. Your internal data is not comsistent.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Randy11]

The link cells have the following formulas in them.

So the link to location in column B

=HYPERLINK("#"&"Sheet2!$b$5",Sheet2!$B$2)

 

[SkipVought]

Does the HL work manually?

What is the TEXT value?

You have to help yourself out and figure out what you code is ACTUALLY doing. No one else can do that for you.

STEP thru your code and report back as required.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}