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