Forum Discussion
Solved
SumColor Function Rounding Up and Down Totals
Hello, I am using the SumColor function with the following code. It is rounding the sums up or down and leaving odd pence across my cash flow. Can anyone tell me a way to stop this happening? ...
Laura_Simpson The described issue is caused by the data type used... Long (Long Integer) does not contain decimals. Try using type Double or Currency, depending on your needs (ie: Dim TotalSum As Double).
For more information on data types, see: https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/data-type-summary
Laura_Simpson The described issue is caused by the data type used... Long (Long Integer) does not contain decimals. Try using type Double or Currency, depending on your needs (ie: Dim TotalSum As Double).
For more information on data types, see: https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/data-type-summary
- This has worked! Thank you so much for your help. I really appreciate it.
