| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosum function
I have a list of numbers with all in same column. When clicking normal
autosum function, Excel determines the sum range for me, including subtotals & grandtotals. How can this happen with same effect in VBA language so that I need not define the sum ranges (variable). E.g. 1 2 3 click autosum : =sum(1:3) 4 5 click autosum : =sum(4:5) click autosum : =sum(above subtotals) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How 2 sort an autosum total list after adding items 2 autosum item | Excel Discussion (Misc queries) | |||
| The copy down function for autosum gives wrong answers | Excel Discussion (Misc queries) | |||
| Autosum function not working | Excel Discussion (Misc queries) | |||
| Where is the result after I do an autosum function? | Excel Discussion (Misc queries) | |||
| Autosum function disappeared/knocked out | Excel Discussion (Misc queries) | |||
Threaded Mode
