| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change data in a formula
Here is s snip of the code that I want to be able to enter a variable
into via a Input Box for the user to enter. The piece I want to enter is the 20070904log.xls bit as this changes on a daily basis. ActiveCell.FormulaR1C1 = _ "=IF(ISNA(VLOOKUP(RC[-8],'N:\1._Document_Version_Control_Log \Logs\20070904Log.xls'!DirName,1,FALSE)),""This is a new or modified Dir "",""Not a new Dir"")" So any (polite!) suggestions would be welcome. Thank you Mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking data that won't change when original formula changes | Excel Discussion (Misc queries) | |||
| Formula for change background according to data | Excel Discussion (Misc queries) | |||
| Need a formula to change data result weekly. | Excel Worksheet Functions | |||
| How does Data Validation change with a formula change? | Excel Worksheet Functions | |||
| How do change formula to permanent data? | Excel Discussion (Misc queries) | |||
Threaded Mode
