Activeworkbook.SaveAs "C:\Documents and Settings\user\Desktop\" &
Range("A24").Value & ".xls"


replace user with your user name or even ALl Users.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Greg B" wrote in message
...
I am looking to have a workbook save using the name on a worksheet called
"title" using cell a:24 as the name.

I also would like this to save to the desktop.

How would I do this please

Greg