| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting total cells once subtotalled
I can record the code to sort and subtotal some data, but I am having trouble
getting it to then only select the total columns and copy them to another sheet. Can anyone help with some code that will select the cells, based on the fact that they will move each time? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting total cells once subtotalled
use specialcells(xlvisible).copy
-- Don Guillett SalesAid Software "cjneth" wrote in message ... I can record the code to sort and subtotal some data, but I am having trouble getting it to then only select the total columns and copy them to another sheet. Can anyone help with some code that will select the cells, based on the fact that they will move each time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing a subtotalled worksheet | Excel Discussion (Misc queries) | |||
| Selecting values from a range that equal a specific total | Excel Worksheet Functions | |||
| Sort a Subtotalled List? | Excel Discussion (Misc queries) | |||
| How to copy subtotalled cells to a new worksheet (in a macro), wi. | Excel Discussion (Misc queries) | |||
| Selecting all sub-total within a Pivot? | Excel Discussion (Misc queries) | |||
Linear Mode
