On Fri, 06 Feb 2004 04:01:20 GMT, "Warren" wrote:

Can someone please help?

The macro I am writing reads in a date from Cell A1, which is formatted as
dd/mm/yy. I want to create a new sheet with this date as the name. I know
that the sheet name cannot have "/" in it. The sheet is protected and I
cannot unprotect it.

So what is the code to read in this date and convert it to a text string in
the format of dd-mm-yy?

Format(Activesheet.Range("A1"), "DD-MM-YY")


---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *