Subtotal detail reference?
Assume column C contains numeric data which is subtotalled
Then you could try: dim rng as range set rng = Columns(3).SpecialCells(xlConstants,xlNumbers) rng.entireRow.copy Worksheets("Sheet3").Range("A1") Regards, Tom Ogilvy tim ellis wrote in message ... I have created a macro to sort and subtotal my worksheet. I would now like to be able to copy the detail rows from each subtotal into a new worksheet. Question: Is there a way to reference the detail rows within a subtotal? ie== For each ??? in ..... Thanks.... Tim |
All times are GMT +1. The time now is 01:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com