Results 1 to 8 of 8
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    why 0,00 value not show correct in sheet (2000 sr -1)

    The amcro in wbook make a calculation based index in column and row....
    Why in sheet STAT_L0953 when the result is 0,00 i see -1,13686837721616E-13 and not blank????
    See for example cell AM16 in STAT_L0953.... or other red 0,00 in the same sheet

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: why 0,00 value not show correct in sheet (2000 sr -1)

    It's caused by small rounding errors. Try changing

    VCODES(A.Row - 1, FNDCOL) = VCODES(A.Row - 1, FNDCOL) + FR.Columns("I").Rows(C.Row)

    to

    VCODES(A.Row - 1, FNDCOL) = Round(VCODES(A.Row - 1, FNDCOL) + FR.Columns("I").Rows(C.Row), 2)

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: why 0,00 value not show correct in sheet (2000

    Work perfect!
    Tks.

  4. #4
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: why 0,00 value not show correct in sheet (2000 sr -1)

    Hans, sorry me but only to understand....
    I test the macro, now, with STAT_L0953_TEST, but the code go in error...."runtime 9"...
    I have see, peraph because in last cell for each column (from D to EB) noa are present a filled cells, or other case?
    If yes, is possible to set the last cell based the last cell filled in column A of STAT_L0953_TEST..
    Tks.
    New attach

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: why 0,00 value not show correct in sheet (2000 sr -1)

    Try changing

    Set RNG = FS.Range("D2", FS.Cells(FS.Rows.Count, "A").End(xlUp).Offset(-1, ...

    to

    Set RNG = FS.Range("D2", FS.Cells(FS.Rows.Count, "A").End(xlUp).Offset(0, ...

  6. #6
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: why 0,00 value not show correct in sheet (2000 sr -1)

    <img src=/S/artist.gif border=0 alt=artist width=34 height=29>!!!!
    tKS.

  7. #7
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: why 0,00 value not show correct in sheet (2000

    hI Hans...Good Morning...
    i think.... during the macro work when i can put in column EJ (insted a formula) the summ of variuos amount ????
    Pearph i can use a counter to summ???
    If yes in wich part of code i am sure to insert in EJ the total...
    Attached new file

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: why 0,00 value not show correct in sheet (2000

    The formulas work well, so why change it?

Posting Permissions

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