Search Through range cells in multiple sheets

[excelgirl84]

Hello,
I am trying to search through a few sheets in a work book for a specific number that could be in a range of cells and once found it will rename that sheet.

So lets say I have 8 sheets in a workbook and I need to rename the sheet based on a value in a cell, the cell can slightly vary though, so I would need to say something like this:

For each sheet in workbook
and for each cell in range E1:N13

If we find value 123456 then rename that sheet to New Name1

If we find value 7891011 then rename that sheet to New Name2

I have spend hours trying figure this out and just can't for the life of me get anything to work.

There will never run into the same value in multiple sheets so that won't be an issue.

Sample file attached with just 2 sheets for testing code

help is much appreciated!

[excelgirl84]

I solved it myself! Yay! In case anyone is looking for something like this I'll paste my code below. Its based on if there were 4 sheets in a workbook and if i'm just naming them the same as the value i'm looking for. That can be tweaked to anything though.

Please Login or Register  to view this content.