| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code To Insert Cell Reference
The following line opens the macro "Recalculate" in the file "Template.xls":
Application.Run "'Template.xls'!Recalculate" The problem is the name of the file often changes. That change is recorded in cell "C27" of worksheet "Customize". Can someone tell me the code to have the line reference this cell? I've tried many variations of: Application.Run "'" & Sheets("Customize").Range("C27").Value & "'!Recalculate" with no luck. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INSERT OBJECT BASED ON CELL REFERENCE | Excel Worksheet Functions | |||
| Can I insert a cell reference into a block of text? | Excel Discussion (Misc queries) | |||
| How can I insert a cell reference in a footer (eg for variable foo | Excel Discussion (Misc queries) | |||
| Need code to insert cell value | Excel Programming | |||
| need code to insert cell value | Excel Programming | |||
Threaded Mode
