| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for saving files where title is made from cell references
Hi,
I was wondering how you would create a macro that saves the file as with a title made from cell references in the sheet. Kindest Regards, Juliodenero |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Macro for saving files where title is made from cell references
will save to desktop with the value of cell A1
Sub SaveAs() ActiveWorkbook.SaveAs Filename:=Range("A1").Value & ".xls" End Sub " wrote: Hi, I was wondering how you would create a macro that saves the file as with a title made from cell references in the sheet. Kindest Regards, Juliodenero |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I put title on top of chart already made in Excel? | Charts and Charting in Excel | |||
| Cell References Between sheets or Files Not Working | Excel Discussion (Misc queries) | |||
| Can I have a value in a chart title that references a cell? | Excel Discussion (Misc queries) | |||
| Macro without cell references...... | Excel Discussion (Misc queries) | |||
| Can a macro be made to run on entering or leaving a cell? | Excel Discussion (Misc queries) | |||
Linear Mode
