Macro to set Y for a 0 value works where is not intended to

Hello guys,

So i have a huge spreadsheet and a huge macro.
It's basically a huge stocklist. Part of the code i'm using is :

Please Login or Register  to view this content.

That basically means that if i have 0 stock , then delivery time is 0,
And if stock is different from 0, delivery time should be 5.

Problem is, the code works and sets 0 for stocks that are 0, but ALSO for stocks that include 0. So that means that if i have 205, 190 or 2803 units in stock, the macro will see that 0 there and will set 0 delivery date.
Any idea how to fix this ?


Also, after this stocklist is copied on a different sheet, i use the below code to set all the lines that had 0 as delivery time as Y on a different column (basically it says it's 0 stock, so it's a YES for Out of stock)

Please Login or Register  to view this content.

Problem is that it displays Y where it should, and 0 elsewhere. Is there a way i can make it to display only Y for true , and nothing for false?

Any help would be greatly appreciated.
Thanks,

Alex

That's a nicer and shorter way of putting it.
Sadly, still the same issue.

"2093 Y"
IT still does not ignore the 0 inside ...

Thing is, i got a sheet where i sort things out and i set delivery time to 5 or 0
Then everything is copied to a new sheet, where there is the additional column for Out of Stock (Y or blank).

basically the macro just looks if there's a 0 in Col J (delivery time).
That piece of code seems the work fine.

just the code that displays 5 or 0 does not work properly...

morning guys,

Any more ideas / help out here ?

Thanks,