Worksheet name = cell value
 

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.

Worksheet name = cell value
 

Hi:

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

Regards,

Vasant.

"MC" wrote in message
...
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.