| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do you use EXCEL formula in properties of file (cell content)
I have an EXCEL template. I would like the "Subject" in the properties
information to automatically pick up the cell contents from the worksheet. I have named the cell as a range. Is it possible to use a fromula to select this information automatically? |
|
#2
|
|||
|
|||
|
How do you use EXCEL formula in properties of file (cell content)
Hi,
You will have to use VBA code. Check the samples he http://www.cpearson.com/excel/docprop.htm -- Lep pozdrav, Peter Jaušovec http://blog.jausovec.net http://office.jausovec.net "chiefcook" wrote: I have an EXCEL template. I would like the "Subject" in the properties information to automatically pick up the cell contents from the worksheet. I have named the cell as a range. Is it possible to use a fromula to select this information automatically? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can i get an If formula in excel to edit another cell? | Excel Worksheet Functions | |||
| Why does Excel show a formula in ONE cell ? | Excel Discussion (Misc queries) | |||
| Where does Excel get the default properties without startup file? | Excel Discussion (Misc queries) | |||
| Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
