Macro not returning correct value

[AccountingJ]

Hello all

I have a macro that should look at column 30. That value can be blank, be 0.00 or any number greater than zero. What I would like for it to do is if the cell in column 30 is greater than zero to pick up that value in move it to another sheet, if the cell is empty or = 0.00 then return the value found in column 3. Well if the value happens to be 0.00 it doesn't return value found on column 3, it still returns the value on column 30. Any ideas why?

If the value is null, it returns the value on column 3 which is right.

Please Login or Register  to view this content.

[AccountingJ]

Think I got it. I changed it to this:

Please Login or Register  to view this content.

and it seems to work just fine.

[Marc L]

Hi !

As a cell value can obviously not be equal to its text display like "0.00"
so better is working with cell text instead of an array from values !
As you can easily check your array data during the execution …