Help Evaluating a Formula in VBA

[reberryjr]

I've reviewed multiple sites (including this one) and can't seem to get the Evaluate piece to work. The first line in the snippet below produces the desired result. The other 3 all produce a Value error. I'd really like to just put the value in these cells. If it would be faster to copy and paste values, I can do that.

With mS.Range("S" & mALLR + 1 & ":S" & mSLR)
    .Value = "=IFERROR(VLOOKUP(RC[-16],'Names'!C4:C12,9,FALSE),""Review"")"
    '.Value = Evaluate("=IFERROR(VLOOKUP(RC[-16],'Names'!C4:C12,9,FALSE),""Review"")")
    '.Value = Application.Evaluate("=IFERROR(VLOOKUP(RC[-16],'Names'!C4:C12,9,FALSE),""Review"")")
    '.Value = [=IFERROR(VLOOKUP(RC[-16],'Names'!C4:C12,9,FALSE),""Review"")]
End With

 

[Scott Huish]

How about

With mS.Range("S" & mALLR + 1 & ":S" & mSLR)
.Formula = "=IFERROR(VLOOKUP(RC[-16],'Names'!C4:C12,9,FALSE),""Review"")"
.Value=.Value
End With

 

[reberryjr]

How about

With mS.Range("S" & mALLR + 1 & ":S" & mSLR)
.Formula = "=IFERROR(VLOOKUP(RC[-16],'Names'!C4:C12,9,FALSE),""Review"")"
.Value=.Value
End With

@Scott Huish

.Value = .Value

is an option I've used a lot in the past, and I can use it again. I'm curious where I was going wrong with the Evaulate attempts.