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

1. ## 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. ## 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. ## Re: why 0,00 value not show correct in sheet (2000

Work perfect!
Tks.

4. ## 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. ## 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. ## 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. ## 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. ## 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
•