| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum a Column of Variable length
Hi,
I wish to put a total AT THE BOTTOM of a list of numbers in a macro. The list is variable length and I want to use the subtotal(109, function as there will be filters applied to the data and I only wish it to add items displayed. I tried this but it crashed on the last line. Help Please!! LastRowNumber = Range("D65536").End(xlUp).Row Moveup = LastRowNumber - 2 ActiveCell.SpecialCells(xlLastCell).Select ActiveCell.Offset(1, -1).Range("A1").Select ActiveCell.FormulaR1C1 = "=SUBTOTAL(109,R[-Moveup]C:R[-1]C)" |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
| Combining workbooks with some variable field names | Excel Discussion (Misc queries) | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Threaded Mode
