I have a macro that is attempting to insert a UDF into the used range of column B, then replace the formula with values. Here is a portion of the code:

```
With rng
.FormulaR1C1 = "=ConvertName97(RC[-1])"
.Copy
.PasteSpecial (xlPasteValues)
Application.CutCopyMode = False
End With
```

The problem is that the cells in rng display "=ConvertName97(RC[-1])" (without the quotes) instead of the calculated value. If I type the UDF directly into the cell, or if I use the Insert Function Wizard, I get the same results (the Formula Result bar in the Function Wizard gives me the correct value, but the cell still displays the formula).

The only way I can get it to work is the put the formula into another cell in my workbook (either by entering it manually or using the wizard) and then copying it to my range.

I have verified (several times) that Calculation is automatic, and I have also recalculated the sheet. I have also verified that View Formulas is not checked. I am probably overlooking something incredibly simple, I just have no idea what it could be. Any help would be greatly appreciated.