ActiveSheet.Name = Range("D1").Value & Right(Range("F1").Value,3)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mmetin" wrote in message
...
Hi,

I want to give my worksheet a name, which is a combination of two cells.
Example:

Cell D1 = ExperimentA
Cell F1 = Sample#01

The name of the worksheet has to get the whole data of cell D1 and the
last 3 charachters of cell F1 (ExperimentA#01).

Please help me.