ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SUMIF in VBA on VBA variables? (https://www.excelbanter.com/excel-programming/325224-sumif-vba-vba-variables.html)

Don Wiss

SUMIF in VBA on VBA variables?
 
I need the functionality of SUMIF in my VBA code. But not for a range.
These are Variant variables (two vectors of same length and a criteria).
For now I'll loop.

Don <donwiss at panix.com.

Bob Phillips[_6_]

SUMIF in VBA on VBA variables?
 
You could drop them into a worksheet range and then use SUMIF from within
VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Don Wiss" wrote in message
...
I need the functionality of SUMIF in my VBA code. But not for a range.
These are Variant variables (two vectors of same length and a criteria).
For now I'll loop.

Don <donwiss at panix.com.





All times are GMT +1. The time now is 06:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com