Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum command in VBA
I have a xcel spreadsheet that reads data from an Access
database. Since the database determines how many rows are in the database - I need to programatically create the totals at the bottom of a column.... something like: ws.[c19].Offset(iro, i) = SUM(ws.[c19].Offset(0, i):ws. [c19].Offset(irow,i)) but of course that gives an error .... I know this can't be that difficult! Thanks, Sally |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum command in VBA
ws.[c19].Offset(iro, i).Formula = "=SUM(" & _
ws.Range(ws.[c19].Offset(0, i),ws.[c19].Offset(irow,i).Address & ")" -- Regards, Tom Ogilvy sally wrote in message ... I have a xcel spreadsheet that reads data from an Access database. Since the database determines how many rows are in the database - I need to programatically create the totals at the bottom of a column.... something like: ws.[c19].Offset(iro, i) = SUM(ws.[c19].Offset(0, i):ws. [c19].Offset(irow,i)) but of course that gives an error .... I know this can't be that difficult! Thanks, Sally |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One command in one cell initiating another command in another cel. | Excel Worksheet Functions | |||
command code ( GOTO command) in formula | New Users to Excel | |||
command button add another command | Excel Discussion (Misc queries) | |||
Pivot Table Error Message - "Command Text not set for command obje | Excel Discussion (Misc queries) | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) |