Rename Tab Based on Cell Format

Hello,

I'm trying to find some code that can rename a tab based on a certain cell's contents.

I have a random cell (the row is completely random, the column will always be Column A).

The cell is always an account number- like this: "Account Number 1234567"- the first 16 characters will always be the same, so I'm thinking looking for some VBA code that can recognize the first 16 characters are "Account Number ", and name the sheet the account number "1234567" in this example.

The account number may vary in length, so the tab should be named whatever characters 17-End are (so I guess it would just remove the first 16 characters?).

I don't expect anyone to build this code from scratch for me (you know...unless you want to - I'm thinking you guys can post whatever similar code you have and I can modify it to meet this purpose?

Thanks in advance,

Chad

Hi hope this helps

Please Login or Register  to view this content.

This worked perfectly, and you're my VBA HERO!

Thanks so much!

I am glad I was able to help.