Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaR1C1 Help
Range("Temp_Col").FormulaR1C1 = "=-SUMIF(" & DataArray & ",RC1,OFFSET(" &
DataArray & ",0,R1C,ROWS(" & DataArray & "),1))" Does anyone know how/if I can get this formula results as a value not the actual formula, so I do not have to copy paste special values the range afterwards? Thanks in advance -- Helping Is always a good thing |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaR1C1 Help
I have no idea what DataArray is, so I cannot be explicit, but you can use
SUMIF in VBA. Range("Temp_Col").Value = Application,SUMIF(rnd_to_check, value to test,range_to_sum) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "QuietMan" wrote in message ... Range("Temp_Col").FormulaR1C1 = "=-SUMIF(" & DataArray & ",RC1,OFFSET(" & DataArray & ",0,R1C,ROWS(" & DataArray & "),1))" Does anyone know how/if I can get this formula results as a value not the actual formula, so I do not have to copy paste special values the range afterwards? Thanks in advance -- Helping Is always a good thing |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaR1C1 Help
Bob DataArray is just the range that the formula offsets against. it holds
the criteria the formula uses -- Helping Is always a good thing "Bob Phillips" wrote: I have no idea what DataArray is, so I cannot be explicit, but you can use SUMIF in VBA. Range("Temp_Col").Value = Application,SUMIF(rnd_to_check, value to test,range_to_sum) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "QuietMan" wrote in message ... Range("Temp_Col").FormulaR1C1 = "=-SUMIF(" & DataArray & ",RC1,OFFSET(" & DataArray & ",0,R1C,ROWS(" & DataArray & "),1))" Does anyone know how/if I can get this formula results as a value not the actual formula, so I do not have to copy paste special values the range afterwards? Thanks in advance -- Helping Is always a good thing |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
FormulaR1C1 Help
Bob, your function does work but I cannot get the formula to read the
criteria for each cell in the column Thanks -- Helping Is always a good thing "Bob Phillips" wrote: I have no idea what DataArray is, so I cannot be explicit, but you can use SUMIF in VBA. Range("Temp_Col").Value = Application,SUMIF(rnd_to_check, value to test,range_to_sum) -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "QuietMan" wrote in message ... Range("Temp_Col").FormulaR1C1 = "=-SUMIF(" & DataArray & ",RC1,OFFSET(" & DataArray & ",0,R1C,ROWS(" & DataArray & "),1))" Does anyone know how/if I can get this formula results as a value not the actual formula, so I do not have to copy paste special values the range afterwards? Thanks in advance -- Helping Is always a good thing |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What Does FormulaR1C1 Do? | Excel Programming | |||
FormulaR1C1 | Excel Programming | |||
FormulaR1C1 | Excel Programming | |||
FormulaR1C1 | Excel Programming | |||
FormulaR1C1 | Excel Programming |