Mark,

Select the cells, then use Edit / Go to... Special Visible Cells Only, OK, then copy and
paste.

HTH,
Bernie
MS Excel MVP


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