Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VBA Code - NAME SEVERAL VARIABLE cells
I have a large workbook with more than a thousand rows. After sorting, the
rows are separated into 18 groups. I total each group (column D) by using sum in active cell macro (naming the group totals Total1 to Total18). I'd like to write a macro to name each total (cell) so I can use the name of each or a combination of the named cells. How can I write a macro for this situation? ActiveWorkbook.Names.Add Name:="saytotal1", RefersToR1C1:==????????? How can I write a macro to name SEVERAL unknown/variable cells? Before sorting, the named ranges would be deleted, then, sum each group and re-name (use the macro that I need VERY BADLY) the new total (cell) for each group. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
VLOOKUP for Zip Code Ranges | Excel Worksheet Functions | |||
variable code?? | Excel Discussion (Misc queries) | |||
code to Copy cells from the above row. | Excel Worksheet Functions | |||
how can i select all the cells with same color on a sheet if there are multipale colors by vba code | Charts and Charting in Excel |