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
Bookmarks