Rename sheets

[TonyBraxton]

Hi,

In sheet 1 ("setup") I have a list of 5 names. (F8-F12)
I want sheet 2-6 to rename too whats in these cells.

Could someone help me?

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[salim ali]

copy this Macro in a module

Please Login or Register  to view this content.

[TonyBraxton]

This doesn't work..?
Mac - excel 2011..

[berlan]

Works for me -- what seems to be the problem?

Please Login or Register  to view this content.

[TonyBraxton]

Nothing really happens.
Should this be pasted into the sheets or in a module?
I am sorry, but are new in this part of excel..

[berlan]

Both would work, but for general-purpose code I'd use a standard module.

[TonyBraxton]

Now it works! Thanks!