| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Displaying values rather than formula in cells
I have the following in a worksheet change event:
Target.Offset(0, 1).FormulaR1C1 = "=SUMPRODUCT(--(WE_Date_Raw=DATE(YEAR(RC[-1]),MONTH(RC[-1]),DAY(RC[-1]))),(Defects_Raw))" Target.Offset(0, 2).FormulaR1C1 = "=SUMPRODUCT(--(WE_Date_Raw=DATE(YEAR(RC1),MONTH(RC1),DAY(RC1))), (Opportunities_Raw))" I want it to display the results in the cells instead of the formulas. What do I need to change to get this to do what I want? Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for displaying only the last entry of a group of cells | Excel Worksheet Functions | |||
| Displaying temporary values on formula cells. Is this possible?q | Excel Discussion (Misc queries) | |||
| Formula for displaying in 1 cell Lowest value from multiple other cells | Excel Worksheet Functions | |||
| Comparing values in two columns and displaying missing values in n | Excel Programming | |||
| Displaying Formulas and Values of the Same Cells | Excel Programming | |||
Threaded Mode
