Posted to microsoft.public.excel.programming
|
|
VBA Array Formula
Hi
as a starting point:
http://www.xldynamic.com/source/xld.ColourCounter.html
"SMS - John Howard" wrote:
I am endeavouring to sum an amount column in a XP Pro spreadsheet based on
various criteria such as Client ID Number, Product ID, DateRange etc with
the result passed to a variable.
I am assuming that a VBA produced array formula is the best approach.
I am comfortable with just the above criteria but one final condition has me
stumped
That is, in additional condition to the above is that I only want to include
cells in the amount column that have an interior.colorindex applied. In
other words Interior.colorindex < xlNone.
All attempts so far, to apply the color condition to various formats of the
amount range have resulted in various error messages.
Can anyone save my sanity on this one
TIA
John Howard
Sydney, Australia
|