Sheet Name

[dcwinter]

Hi,

As part of a macro, I have copied a sheet within a workbook, and I want to rename that sheet as the value in Cell B3.

This will mean that a new sheet can be created for individual customers.

I don't know how to do this - I tried to simply copy the value in cell B3 and then paste it into the tab name at the bottom of the sheet as a recorded macro, but that doesn't work.

Any ideas???

:x

 

[Paddy1979]

try

ActiveSheet.Name = [b3].Value

 

[VoG]

Try

ActiveSheet.Name = Range("B3").Value

 

[dcwinter]

Thank you very much! It worked!