| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Naming Worksheets and Footers
1. If the workbook is saved use below formula in A1.
=MID(CELL("filename",$A$1),FIND("]",CELL("Filename",$A$1))+1,255) 2. Needs vba code. Try to record a macro. Regards, Shailesh Shah http://in.geocities.com/shahshaileshs/ (Free addins Excel Menu-2003 for Excel-2007) If You Can't Excel with Talent, Triumph with Effort. "Tim H" wrote in message ... Two questions - How do I set the name of a worksheet to a cell in a list - say, A1 on sheet 1? How do I set the footer to grab data from cells - say, A2 and B2? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Footers across worksheets | Excel Discussion (Misc queries) | |||
| Add footers in 20 worksheets at once | Excel Discussion (Misc queries) | |||
| Different headers, same footers on multiple worksheets | Excel Discussion (Misc queries) | |||
| No headers & footers in the worksheets | Excel Worksheet Functions | |||
| Pre-set headers and footers for new worksheets | Excel Discussion (Misc queries) | |||
Hybrid Mode
