| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visible rows copy to different worksheet
ActiveSheet.Outline.ShowLevels RowLevels:=2 In a macro I set a data filter to obtain Subtotals (like on the data menu). Now instead of 8,000 rows I have 50 Subtotal rows that are visible. The numbers of rows varies by data set. When I copy the data (to a different worksheet) all 8,000 rows are copied. How do I copy only the visible rows? Cornfused but ultimately greatful for your help. Craigm -- Craigm ------------------------------------------------------------------------ Craigm's Profile: http://www.excelforum.com/member.php...o&userid=24381 View this thread: http://www.excelforum.com/showthread...hreadid=383640 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy rows and paste onto visible only | Excel Discussion (Misc queries) | |||
| Excel copy only visible rows from autofilter | Excel Discussion (Misc queries) | |||
| Chart Area visible but cannot access rows and columns on worksheet | Charts and Charting in Excel | |||
| Can I copy data from only the visible rows in Excel? | Excel Discussion (Misc queries) | |||
| Copy visible rows with data to new file | Excel Programming | |||
![Craigm[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
