| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To run the formula from any active cell
In my macros I wrote the formula as follows.
ActiveCell.FormulaR1C1 = "=IF(COUNTIF([item.xls]item!C[-11],RC[-6]),VLOOKUP(RC[-6],[item.xls]Item!C[-11]:C[-1],11,0),0)" the output formula would be as like this: =IF(COUNTIF([item.xls]item!B:B,G7),VLOOKUP(G7,[item.xls]item!B:L,11,0),0). So is it possible to write the formula the same as that of seconed formula in my macro.Becuuse I need to run the formula from any active cell which may be L7 or M7. So please help me to write that formula to enable to run from any active cell. With thanks Pol |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use the active cell in an Excel formula | Excel Worksheet Functions | |||
| IF information is in cell A8 then Formula is active? | Excel Worksheet Functions | |||
| referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
| Active Cell To Change Formula | Excel Discussion (Misc queries) | |||
| how to copy a trendline formula into an active cell ? | Excel Discussion (Misc queries) | |||
Threaded Mode
