| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing a Range
Hi Norma,
Application.Worksheetfunction.sum(range(cells(2,1) ,cells (2,256))) give you the sum of row 2 regardless wheather the cell is empty or no empty. Best Regards Bill -----Original Message----- I am working in VB for Aps. I am trying to sum a row of cells, I don't know how many cells will be involved (the number of cells will always vary). I am at a deadend!! Anyone have any suggestions?? Norma . |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Summing a Range
How about
Application.Worksheetfunction.sum(rows(2)) then. -- Regards, Tom Ogilvy Bill Li wrote in message ... Hi Norma, Application.Worksheetfunction.sum(range(cells(2,1) ,cells (2,256))) give you the sum of row 2 regardless wheather the cell is empty or no empty. Best Regards Bill -----Original Message----- I am working in VB for Aps. I am trying to sum a row of cells, I don't know how many cells will be involved (the number of cells will always vary). I am at a deadend!! Anyone have any suggestions?? Norma . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing a range of cells based on criteria in another range | Excel Worksheet Functions | |||
| Summing up range of data | Excel Worksheet Functions | |||
| Summing a Range With N/A's | Excel Discussion (Misc queries) | |||
| Summing between Range | Excel Discussion (Misc queries) | |||
| Summing a range that changes | Excel Discussion (Misc queries) | |||
Linear Mode
