| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Sum returns Wrong Format
I would have used double.
code_hungry wrote: Thank you all for your reply. The Currency solution was the one that worked. Because you were so quick to reply, I was able to give this project back to my boss on the same day. He was happy. Thanks again. "JLGWhiz" wrote: Dim MySum As Currency "code_hungry" wrote: If Anyone could give me a hand.... Cell E33 value is "$2,793.70" Cell F33 value is "$450.00" My code rounds up the result and returns the value 3244. I need the value to be but I need it "3,243.70" What do I have to change in the code below? Thanks Sub sum() Dim MySum As Integer Dim MyRange As Range Set MyRange = ActiveSheet.Range("E33:F33") MySum = Application.WorksheetFunction.sum(MyRange) Range("F46").Value = MySum End Sub -- -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Strange? VBA code returns wrong date format (not a date) | Excel Programming | |||
| cell returns wrong value | Excel Worksheet Functions | |||
| Row() function returns wrong row and more.. | Excel Worksheet Functions | |||
| Lookup returns wrong value | Excel Worksheet Functions | |||
| SUM returns wrong result | Excel Worksheet Functions | |||
Hybrid Mode
