Group and Outline

teknovision · May 26th 2004

Hi all!

I have created a macro that results in a Grouped list. Now, I would like to copy and paste the 'headers' of each group without the 'detail' into another spreadsheet.

Everytime I select, copy the whole list it also pastes the 'detail' under each 'header'.. . Any help would be muchly appreciated?

Any help would be muchly appreciated.. Cheers,

Phil

Ps. Nice new forum btw!!

Anonymous · May 26th 2004

Use the SpecialCells to select just the visible data. For example
Range("A4:B17").SpecialCells(xlCellTypeVisible).Copy

pradeep_atm · Dec 9th 2004

Re: Group and Outline

Instead of vb code, one can use the following way

Select the entire rows, press F5(or Ctrl+G or ) and then special and then select visible cells only and then the ususal copy and paste. Instead Alt+; will help to select the visible cells alone.

Group and Outline

Participate now!

Share