Forum Discussion

Peter Sunden's avatar
Peter Sunden
Copper Contributor
May 29, 2018

Comma versus dot causes problems and I can't be alone or?

Hi, new in this forum and lives in Sweden (guess that one is a lead on the problem, Sweden I mean).   Writing a macro (as newbie) and stumbled into a problem working with constants containing decim...
Formulas & Functions
Need Help
Logaraj Sekar's avatar
Logaraj Sekar
Iron Contributor
May 30, 2018

Hi Peter Sunden

 

Try 

Dim sCurr As Decimal (or) Dim sCurr As Double

 

Instead of 

Dim sCurr As Decimal

  • Peter Sunden's avatar
    Peter Sunden
    Copper Contributor
    May 30, 2018

    Thanks Logaraj

     

    Using Single today and not Decimal. Have tried with Double with no result...

     

    Br

    Peter

Resources