| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Undesired Rounding in VBA; accumulating values
Sorry I don't have a copy of the source code handy, but here goes:
I'm reading values from a series of cells in one sheet (stored in a 2D array), then accumulating values in a destination sheet. The array is type Double; using XL2002. The source data goes to three decimal places (ex. 0.245), but the value accumulated is rounded (ex. 0.25). Source Sheet reading: ActiveCell.Offset(Row, Column).Value = dblArray(RV,CV) Destination Sheet accumulating: ActiveCell.Offset(Row, Column).Value = ActiveCell.Offset(Row,Column).Value + dblArray(RV,CV) -Glenn Any clue as to why this is happening? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| On exit from edit, Excel jumps to remote undesired cell. | Excel Discussion (Misc queries) | |||
| Undesired links: Pasting from one excel document to another | Links and Linking in Excel | |||
| Rounding up values | Excel Worksheet Functions | |||
| accumulating values generated daily | Excel Worksheet Functions | |||
| Accumulating Values in a Pivot table | Excel Discussion (Misc queries) | |||
Threaded Mode
