Hi guys,

I've got a list of names in say A1:A50 in Sheet1. I want to rename the 50
immediate* sheets to the right of Sheet1 with the 50 names in the list, in a
"transpose-like" fashion, i.e. the name in A1 replaces the name of the sheet
just to the right of Sheet1, that in A2 goes into naming the sheet 2 tabs to
the right of Sheet1, and so on. I'll like the sub to return me to Sheet1 at
the end of the task. Thanks.

*there may more than 50 sheets to the right of Sheet1. But if there's less,
just rename from A1 down until the last sheet to the right.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----