Numbers not recognized as such

[d_abbatelli]

Hello

Here is my macro.. It processes data from a .csv imported.
I managed to get the data I need from one sheet to the other. Now I would like to eliminate some rows (where the value of the transaction is positive).
However, it looks like the values in the range "transactions" (and thus cell) are not recognized as numbers.
Checking if they are positive (cell >= 0) gives a type error, and indeed it the "IsNumeric" gives a false (and the TypeName gives back a variant).
The numbers are formatted something like -123,45, but I also tried using plain integers (1, 10, 100) and they are still not recognized as numeric.

What is the problem?

Please Login or Register  to view this content.

[Jakobshavn]

You may have blanks or other non-visible characters in the cells. This first step is to see what you have. Pick a cell and run:

Please Login or Register  to view this content.

[d_abbatelli]

You may have blanks or other non-visible characters in the cells. This first step is to see what you have. Pick a cell and run:

Please Login or Register  to view this content.

Here is what I got, on a cell which contains only "10"

Please Login or Register  to view this content.

On a cell that contains -178,3:

Please Login or Register  to view this content.

Doesn't seem to be any extra character...

[mikerickson]

try

Please Login or Register  to view this content.

[oeldere]

You could try this code.

Please Login or Register  to view this content.

[d_abbatelli]

try

Please Login or Register  to view this content.

This worked!

Thanks!