Dynamic range & sub-total

[Salim]

I have a long excel sheet around 200 rowa by 7 columns
After sorting the sheet and doing the subtotals i would
like to assign ranges for each area of subtotals.
i.e
A1:xxx B1:234 C1:12XF
a2:xxx B2:456 C2:zy34
then subtotal xxx is 2 and the range is from A1 to C2

Thanks

 

[Frank Kabel]

Hi
not really sure what you're trying to do. Do you want this as addition
to Excel's Subtotal feature?

 

[Guest]

What I need is a nameranged for each data that subtotal is
calculating .