Alaphas,
You will need to distinguish the subtotal rows somehow, then create a FOR
NEXT Loop in VBA that will go through the Rows starting at the top towards
the bottom, looking for that distinguishing mark and deleting those rows that
do not have it.

Alex. A

"Alaphas" wrote:

I subtotaled a list of approx 19,000 values. I want to delete the previous
values, and leave only the subtotal lines behind. I am sure there is a
command line that allows us to do this, rather than cutting and pasting for
an hour and a half.