You can, but you will need to PasteSpecialValues if you want that exact
value.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Mark" wrote in message
...
After i have Subtotaled a spreadsheet, then collapsed to show subtotals
can I
copy just the subtotal