adding half value?

Hey all,

I'm sure it's a silly thing I'm missing and I've done some research, but can't seem to find the right answer. My simple code copies the value from previously specified cell, then should add a value of 0,5 and copy back the final sum into the original cell. ie. cell C1 was 1, that 1 is copied to cell X100, 0,5 is added to 1 (so now cell X100 is 1,5) and that value is copied back to C1.

The code:

Please Login or Register  to view this content.

In the above code, if I change 0.5 to 1 - it all works just fine. But VBA just won't add 0,5 to 0,5... What am I missing?

The issue here is that when a cell has already a value of 0,5, the vba code that should add 0.5 (resulting in 1 as a cell value) does not do that.

Regardless of whether my code could be compressed (which an experienced coder could probably do in a split second), your solution doesn't do much apart from replacing a value of 0,5 to 0,05...

See, I knew it was a silly thing it's just a matter of lack of knowledge and experience.

Of course that was the issue. Changed Integer to Single and it works perfectly now.

Thank you!