Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 -- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |