Tom gave me this code to create worksheets with the date on them.

worksheets.Add After:=Worksheets(worksheets.count)
worksheets(worksheets.count).Name = Format(Date,"ddmmyyyy")

What i need to do is on each of these Worksheets i need to put
"Auditor Name" in Range("A2").

I have tried a few things but only get the text on the last sheet.

Please help

--
Message posted from http://www.ExcelForum.com