Worksheet name = cell value

[MC]

I need to set a Worksheet's name equal to cell B3's
value. If I could set it to a Portion of B3's value that
would be better, e.g. Mid(B3,9,20)

any help will be appreciated.

 

[Vasant Nanavati]

Hi:

ActiveSheet.Name = Mid(Range("B3").Value,9,20)

Regards,

Vasant.