in VBA script, make cell values = formula value, not formula
 

Here is a snippet of my code:
Range("Z2:Z100).FormulaR1C1 =
"=IF(ISBLANK(RC1),"""",CONCATENATE(VLOOKUP(msr!R2C 2,tbl.markets,2,0),(TEXT(msr!R4C2,""mmddyy"")),""-"",(TEXT(ROW(RC[-25])-1,""000""))))"
Columns("Z:Z").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks:=True, Transpose:=False

in VBA script, make cell values = formula value, not formula
 

Part of my question disappeared!
So question is, instead of selecting then copying and pasting values. I want
the values to get dumped straight in. Like killing the formula after I'm done
with it only not by cutting and pasting values. Make sense?

in VBA script, make cell values = formula value, not formula
 

Nevermind. I found the answer on Ron's Excel Tips. So easy, yet so elusive.