I have a spreadhseet that uses the "Data", "Subtotals" in VBA obviously to
subtotal items. I want a formula copied down the entire list, after the
subtotal.
I have this all working (probably not as easily as some would have it, but
it works), except at the moment the formula is copied down a static number of
rows.

How do I copy it down to the last cell in my range, not knowing how big the
range is to start with?

Thanks
Dean