| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUM() function not behaving
I have a series of columns with sums at the top of each using the SUM()
function. I want to run the subtotal command across them from VBA using range ("a1")= Worksheetfunction.subtotal(5, Range). But I keep getting back a zero for the result although the columns have numbers in them. Is this due to a flaw with trying to use the SUM() Function or have I gone Crazy. Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Function behaving differently in different spreadsheets | Excel Worksheet Functions | |||
| Getpivotdata behaving flaky | Excel Worksheet Functions | |||
| Cursor not behaving | Excel Discussion (Misc queries) | |||
| OFFSET behaving oddly | Excel Worksheet Functions | |||
| Set Target cell is not behaving | Excel Programming | |||
Threaded Mode
