I took this approach:
My data table has a single-row of headerinfo on Row3 - first data on row 4
downward
I like having a column(1) Inserted in most of my datatables when I use
Auto-Filtering
with a formula in A4 of =SUBTOTAL(3,$B$4:B4) and copied down to the end
of the
data. Label in A3 of "Seq #".

So that when I filter my Column A always gives me a sequential row count of
the visible
cells. Nice feature, huh..

In my Column C cell C1 I entered:

=SUBTOTAL(9,INDIRECT("C3:C"&MATCH(5,$A3:$A20,0)+2) ) and copied across
replacing in each copied cell the two "C"s to the appropriate column letter.
Once
Done it works like a charm.

Hope this helps!!!
It helped me,,,







"dflorine " wrote in message
...
I use a filter to sort data, then use a macro for data calculation. How
can I tell the macro to always choose the first 10 rows for the
calculation, regardless of row numbers?


---
Message posted from http://www.ExcelForum.com/