I have a database that I wish to run a Macro over to count
the number of items (and do further data manipulations)
that meet several different , but specific criteria as
defined thoguh several macros that basically use
Autofilter to select the list of items. Currently at the
bottom left of the sheet (with COUNT selected ) I See the
number but I am looking for a way to pass the number into
another Macro ...

Any Ideas?

I am looking for a shortcut to make use of what is already
being filtered (as opposed to programming in the criteria
through DCOUNT etc.. and extracting from a fixed cell.

Thanks for any replies in advance

Guy,
I think what you are looking for is array functions. To enter as an
array, enter ctrl-shift-enter.

The syntax you're likely looking for is:
Count(if(criterion1,if(criterion2,columntobecounte d)()). Then hit
ctrl-shift-enter.

Hope that helps, Jim



"Guy" wrote in message ...
I have a database that I wish to run a Macro over to count
the number of items (and do further data manipulations)
that meet several different , but specific criteria as
defined thoguh several macros that basically use
Autofilter to select the list of items. Currently at the
bottom left of the sheet (with COUNT selected ) I See the
number but I am looking for a way to pass the number into
another Macro ...

Any Ideas?

I am looking for a shortcut to make use of what is already
being filtered (as opposed to programming in the criteria
through DCOUNT etc.. and extracting from a fixed cell.

Thanks for any replies in advance