How to change VBA formula to value

[zinah]

Hi,

I have below VB formulas and I need to turn each formula to value, can anyone advise how?

Range("AA18:AA42").Formula = "=IFERROR(1-(AD18/AC18),IFERROR(1-(AD18/AC18)," & Chr(34) & Chr(34) & "))"Range("AB18:AB42").Formula = "=IFERROR(AD18/AC18,"""")"
Range("Z18:Z42").FormulaR1C1 = "=IF(RC[-1] = """", """", IF(ISNUMBER(RC[-1]), ""Org. Layer"" & CHAR(32) & RC[-1], RIGHT(RC[-1], LEN(RC[-1])-7)))"
Range("AB18:AB42").Formula = "=IFERROR(AD18/AC18,"""")"
Range("AC18:AC42").FormulaR1C1 = "=IFERROR(COUNTIFS(INDIRECT(IF(R16C25 = ""by Loc"", R14C31, R13C31)), RC25, INDIRECT(R15C31), R13C26, Manipulated_Data!R1C18:R8089C18, ""Regular Employee"", Manipulated_Data!R1C19:R8089C19, ""<>""&""Hourly""),"""")"
Range("AD18:AD42").FormulaR1C1 = "=COUNTIFS(INDIRECT(IF(R16C25 = ""by Loc"", R14C31, R13C31)), RC25, INDIRECT(R15C31), R13C26, Manipulated_Data!R1C18:R8089C18, ""Regular Employee"", Manipulated_Data!R1C19:R8089C19, ""<>""&""Hourly"",Manipulated_Data!R1C83:R8089C83,0)"
Range("AE18:AE42").FormulaR1C1 = "=COUNTIFS(INDIRECT(IF(R16C25 = ""by Loc"", R14C31, R13C31)), RC25, INDIRECT(R15C31), R13C26, Manipulated_Data!R1C18:R8089C18, ""Regular Employee"", Manipulated_Data!R1C19:R8089C19, ""<>""&""Hourly"",Manipulated_Data!R1C83:R8089C83,""<>""&0)"

 

[Michael M]

do this for each formula

with Range("AA18:AA42")
.Formula = "=IFERROR(1-(AD18/AC18),IFERROR(1-(AD18/AC18)," & Chr(34) & Chr(34) & "))"Range("AB18:AB42").Formula = "=IFERROR(AD18/AC18,"""")"
.value=.value
end with

 

[zinah]

Thanks a lot Michael!

 

[Michael M]

....and thx for the feedback