Name Worksheet According to Cell Value?

[kirsty]

Hello. I am wondering why all advice online regarding how to name a worksheet based on a cell value is not working for me? I am trying to write a macro that, when run, cycles through every worksheet in my workbook and names each sheet whatever the value in merged cell P3:S3 is. This value is always a five digit number. Does anyone have any idea where I may be going wrong with this? I have tried at least ten codes from various sources and gotten a a multitude of errors. I think it may be because the value is a number? Very new to VBA.

Thank you!

[Leith Ross]

Hello kristy,

There is no rule against naming worksheets as numbers. You should post the code you using for review.

[kirsty]

Currently I do not have one as I haven't been able to make anything work. I have tried the following:

Please Login or Register  to view this content.

This one from dailydoseofexcel.com (adjusted range to match mine):

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

There were others I tried; these are some of them. All of them produced an error message. Thank you for your help.

[Leith Ross]

Hello Kristy,

By any chance is the worksheet protected? If so, it must be unprotected before the name can be changed.

[kirsty]

The sheet is not protected.