Select the range, press F5, click special and select visible cells only,
click OK, copy and paste

--

Regards,

Peo Sjoblom

"bfordmelson" wrote in message
...
How do I copy/paste subtotaled data without also copying the detail
(hidden
rows)?