Cell A1 Equals Sheet name

**JoshF** · 10-20-2011, 04:01 PM

Attached is summarizing what I am looking for.

My issue is probably on the internet or even on this site, but I cannot seem to find what I am looking for given the complexity of explaining. Basically, I want the sheet name to equal whatever is cell A1.

Step 1:
"project name" in cell 1
Sheet 1
Step 2:
"project name in cell 1
Sheet 1 now linked/says what is in cell 1("project name")

The picture should help explain what I what.

Any help with this process would be greatly appreciated. Thanks.

**tazrockon** · 10-20-2011, 04:06 PM

Sheets(1).name = Cells(1, 1).Value

Still not quite sure what you're asking, but throwing this in a module and running it will set the sheet name to whatever text is in the cell A1.

**tom1977** · 10-20-2011, 04:06 PM

try this

Please Login or Register  to view this content.

**JoshF** · 10-20-2011, 04:14 PM

Originally Posted by tom1977

try this

Please Login or Register  to view this content.

Perfect Thanks. If I wanted to do it on all sheets, I would change ActiveSheet to AllSheet? Thanks

**JoshF** · 10-20-2011, 04:15 PM

Originally Posted by tazrockon

Still not quite sure what you're asking, but throwing this in a module and running it will set the sheet name to whatever text is in the cell A1.

Thanks for the help and exactly what I was looking for

**Whizbang** · 10-20-2011, 04:29 PM

Please Login or Register  to view this content.

**tom1977** · 10-20-2011, 04:34 PM

Whizbang
Your code will generate error because there is no possibility to have two sheets with the same name

**JoshF** · 10-20-2011, 05:01 PM

Originally Posted by tom1977

Whizbang
Your code will generate error because there is no possibility to have two sheets with the same name

It generates some error, but the code itself works. Strange. Thanks Whiz and Tom. Any idea how to get rid of the generated error?

**tom1977** · 10-20-2011, 05:10 PM

Simply You can not to name two different sheets (in the same workbook) with the same name (from the same cell -check this manually without VBA)

**JoshF** · 10-20-2011, 05:33 PM

Originally Posted by tom1977

Simply You can not to name two different sheets (in the same workbook) with the same name (from the same cell -check this manually without VBA)

Thanks Tom for this information and the help today.

**Whizbang** · 10-21-2011, 08:10 AM

My code does not use the same cell to name all sheets. It checks cell A1 of each sheet. If two sheets have the same value in their respective A1, then yes, an error would occur. Otherwise, this will run just fine.

Cell A1 Equals Sheet name

LinkBack

Thread Tools

Rate This Thread

Display

Cell A1 Equals Sheet name

Re: Cell A1 Equals Sheet name

Re: Cell A1 Equals Sheet name

Re: Cell A1 Equals Sheet name

Re: Cell A1 Equals Sheet name

Re: Cell A1 Equals Sheet name

Re: Cell A1 Equals Sheet name

Re: Cell A1 Equals Sheet name

Re: Cell A1 Equals Sheet name

Re: Cell A1 Equals Sheet name

Re: Cell A1 Equals Sheet name

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions