Rename active sheet based on cell value.

[Dagoom]

Hello all,

I was wondering if anyone can help me out here.

I have a few macros set up to copy a sheet, and add a row to my table.

Now what I need to know, can I rename my active sheet based on the bottom value in a range?

I have associated my table as "Table1" and what Would be great is if I could rename a sheet the bottom value in Column A.

Please help me out here, I am so close to finally finishing this project.

Thanks for your time.

[alansidman]

Have a look at this link:

http://www.ozgrid.com/forum/showthread.php?t=65841

[Dagoom]

Thanks Alan, is there any way to have it select the last cell with data in it in a range?

[alansidman]

Yes. Try this:

Please Login or Register  to view this content.

[Dagoom]

Unfortunately what it does is make a new sheet, not just rename the active one.

Is there any way to add renaming the sheet to this macro?

All of my sheet names are numbered 1-100, this macro creates a page from a template, adds a row to my table and now all I need to do is make it rename the page after the new row, which in this case would have "101" as a name.

Please Login or Register  to view this content.

Thanks for your help Alan. I really appreciate it.

Right now my new sheet is called "Template (2)".

I would like it to be named 101 in this case.

Then the next sheet when I run the macro would be 102.

[protonLeah]

Are you adding a new sheet and then renaming it, or just renaming an existing sheet?

[Dagoom]

I am adding a sheet with my one macro, then was planning on adding the second macro to the first to rename it using the last used cell in my table, or range of A column.

[protonLeah]

Try this mods using alansidman's code above:

Please Login or Register  to view this content.

[Dagoom]

THANK YOU SO MUCH!

That works amazingly.

You are the man.

[Dagoom]

Is there any way to make it so if the number in Column A is below 99, it adds a different template?

If not it's not a huge deal, you guys have done more than enough for me.

Oops, sorry for the double post.

[protonLeah]

Something like:

Please Login or Register  to view this content.