K ksmith New Member Joined Oct 8, 2002 Messages 49 Oct 28, 2002 #1 I want to save a worksheet by clicking a button that will save the sheet as the text in a certain cell. So the macro would have to save as the text in a cell. example: cell A1=6315. Save file as 6315. Any ideas would be great! Thanks!