Hi

I asked the question a few days ago how to get a tab name to match the
data in cell h2. Somebody kindly gave the following formula..

Private Sub Worksheet_Activate()
Sheets(1).Name = Range("H2").Value
End Sub

I must be doing something wrong as it doesnt seem to work. I have
entered the formula by right clicking on the tab of the open worksheet
....clicking on "view code" and pasted it into PDFWriter.xla - module1
(Code).....as you may have already gathered I havent got a clue what Im
doing so any help in the simplest of terms would be greatly appreciated

Regards

Nigel


--
Nigel
------------------------------------------------------------------------
Nigel's Profile: http://www.excelforum.com/member.php...o&userid=25696
View this thread: http://www.excelforum.com/showthread...hreadid=394755