Macro to rename sheet

**JRD123** · 12-09-2010, 07:24 AM

Hi There,

I'm looking at creating a macro that inserts a new workbook and renames it to the value in the bottom of my range.

So far I have:

Please Login or Register  to view this content.

But im getting an error 438. Any advice greatly appreciated.

Thanks,

**royUK** · 12-09-2010, 07:43 AM

What's SelectRange?

What'as pagename?

**JRD123** · 12-09-2010, 09:49 AM

Hi,
The select range is how I'm trying to select the bottom cell in my range, and page name is the name of the page where that range is, does that make sense?

Thanks again

**royUK** · 12-09-2010, 10:23 AM

Are they variables that you have given a value. it might be best to attach the workbook

**JRD123** · 12-10-2010, 08:48 AM

Sorry for the delay,

I've attached the sheet.

Basically, when the rename button is clicked on the Test sheet, the Test sheet should rename to Dog4 as that is the last entry on the list, if it went up to Dog10, it should rename to Dog10.

Thanks again

**royUK** · 12-10-2010, 08:57 AM

I think this is what you want. It adds a sheet& renames it

Please Login or Register  to view this content.

**davesexcel** · 12-10-2010, 09:03 AM

Try this

Please Login or Register  to view this content.

**JRD123** · 12-10-2010, 09:15 AM

Thanks very much guys,

both solutions solve my issue!

Kind regards,

**royUK** · 12-10-2010, 09:22 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save