Hide Sheets Based on Cell Value is Hiding Sheets based on Their Tab Position...Help

[pstrever]

I am currently using the following code to hide unused sheets based on cell value "" in Range "C5:C105". The tabs are named 1-100 and I am using Range "B5:B105" as a reference for the code. Issue is this: When the code runs and there is no value in C5, instead of sheet.name 1 (sheet1) being hidden, sheet(101) gets hidden because it is in position 1 in the tab list at the bottom of the workbook. The code works fine if the tabs are A,B,C...and reference Range is A,B,C...but I would like it to work using 1,2,3...Any Ideas?

Please Login or Register  to view this content.

[thomglea]

Maybe this:

Please Login or Register  to view this content.

[pstrever]

Thomglea, That just prevented the sheets from being hidden after they were visible and it is still wanting to unhide sheets based on their TAB positions on the bottom...I may have found a glitch in the sheet hiding matrix

[thomglea]

Nah, just gotta figure out your conditionals. The code below will do what you want by only looking at column C and determining if the cell is blank or not. Change the range to match yours (I made mine small for testing purposes. I was not going to make 100 sheets )

Please Login or Register  to view this content.

[pstrever]

THANK YOU! You're Brilliant.