I'm probably being really stupid here, but I just can't seem to get a hard-coded value in my output cells based on a calculation in the code.
Simply, I want to do:
But have the results in G2:G50 as values rather than formulae.
I could put in the formula then copy & paste as values, but surely there's a way to just get values in the cells without the extra step?!
Thanks
Simply, I want to do:
Code:
Range("G2:G50").Value ="=RC[-1]/100"
But have the results in G2:G50 as values rather than formulae.
I could put in the formula then copy & paste as values, but surely there's a way to just get values in the cells without the extra step?!
Thanks