Results 1 to 3 of 3

Thread: Info: different Value !

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Oct 2011
    Posts
    135
    Rep Power
    14

    Info: different Value !

    Hi,

    We are using the following code, run regularly in Excel 2003
    The list includes only positive numbers: 12.625

    While Excel 2007 does not show the same values ​​...

    Any idea? How do I fix these codes?

    Any advice is appreciated

    Code:
    '--- Dati -50
    Sub Formula()
        Dim x As Long
        Dim Decurta As Double
        Decurta = Sheets("Foglio1").Range("J1").Value
        For x = 2 To Range("A" & Rows.Count).End(xlUp).Row
            Cells(x, 8).Value = Cells(x, 3) - Decurta
        Next
    End Sub
    
    '--------- 2 Dec.
    Sub Decimali()
        Dim x   As String
    
    '---Cerco i decimali nella colonna F e copio i valori nella colonna I
        With Range("F2:F" & Range("F" & Rows.Count).End(xlUp).Row)
            x = .Address
            .Offset(, 3) = Evaluate("if(isnumber(" & x & "),round((" & "int(" & x & "* 100" & ")),0)/100," & x & ")")
        End With
    
    End Sub
    It could be "round(" if the text language is not the same?
    Last edited by PcMax; 04-16-2012 at 03:22 AM. Reason: updating

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •