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

  • Thread starter Thread starter Solutions Manager
  • Start date Start date
S

Solutions Manager

Here is a snippet of my code:
Range("Z2:Z100).FormulaR1C1 =
"=IF(ISBLANK(RC1),"""",CONCATENATE(VLOOKUP(msr!R2C2,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
 
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?
 
Back
Top