ExcelBanter - change SUMIF formula into a vb code

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - change SUMIF formula into a vb code (https://www.excelbanter.com/excel-discussion-misc-queries/108739-change-sumif-formula-into-vbulletin-code.html)

ASU

change SUMIF formula into a vb code

Is it possible to change the formula below into a VB code?

=SUMIF($A$11:A18,A18,$D$11:D18)-SUMIF($A$11:A18,A18,$F$11:F18)
--
ASU

Bob Umlas

change SUMIF formula into a vb code

ans=Evaluate("SUMIF($A$11:A18,A18,$D$11:D18)-SUMIF($A$11:A18,A18,$F$11:F18)"
)

"ASU" wrote in message
...
Is it possible to change the formula below into a VB code?

=SUMIF($A$11:A18,A18,$D$11:D18)-SUMIF($A$11:A18,A18,$F$11:F18)
--
ASU

All times are GMT +1. The time now is 10:15 AM.