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.
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?
Please Login or Register to view this content.