Sub missive()
v = Range("C2").Value
ActiveSheet.Name = v
End Sub

--
Gary''s Student - gsnu200714


"Colin Hayes" wrote:


Hi

I need a small piece of code which will transfer the contents of Cell C2
(merged to G2) to the tab at the bottom of the sheet.

Can someone help?

Thanks.



Best Wishes


Colin