Re-Name Worksheets w/ Macro?

[samuelabyrd]

I need to rename 200 worksheets according to data in column A. The data is sequential, for the most part, and contains 25054, 25055, 25056, etc. How can I easily rename the worksheets without naming each manually?

Thank you.

[HaHoBe]

Hi, samuelabyrd,

do you have one cell showing the new number or is it a range in which these names are to be found?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Ciao,
Holger

[samuelabyrd]

It is a range. The names are in column A, A5:A218. I think I should use the 2nd of the two codes offered, but I'm not sure how to properly format the information that needs to go in the line starting with "ws.Name".

Thank you.

[HaHoBe]

Hi, samuelabyrd,

and then: range on one special sheet or on any? The Index of a Worksheet will always start with 1, so we need to add at least 4 to the Index to match the range.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Ciao,
Holger

[samuelabyrd]

Hi Holger,

Yes the range of information is on a worksheet titled "House Codes".

When I run it, is says, "Check the value in cell 'A5' please." The value in the cell is a numeric text entry, 25045 in this case.

Thank you.

[samuelabyrd]

Any other ideas?

[HaHoBe]

Hi, samuelabyrd,

maybe itīs that the sheet with the codes is renamed and thus not found any more.

Please give the updated version a try:

Please Login or Register  to view this content.

Ciao,
Holger