Naming Worksheets

[LeTiss]

I'm doing some work with Excel, but am having trouble with one aspect

I'm trying to set up a macro that changes every sheet's name in the workbook to the value in cell A2 of the corresponding sheet

If any Excel experts know the answer, I'd be much obliged for guidance

Cheers
LT

[toptrader]

Hi LeTiss

try Application.ActiveSheet.Name=Range("A2")

[LeTiss]

Thanks for the response TT

Could you elaborate?

I've almost given up now

[nigelk]

Hi LT,

if you know how to insert a module, try this one.
(Put it at the beginning of your subroutine)

Dim WS As Worksheet

For Each WS In Application.Worksheets
WS.Activate
WS.Name = Range("A2")
Next WS

If still not sure, let me know.

Nigel.

[LeTiss]

All sorted, cheers fellas