如何在一个字符串VBA中得到第二次的次刺?

I have cell formula like

我有细胞配方

I want to replace specific # with check# with an integer I have tried this

我想用一个我尝试过的整数来替换特定的#

result = Replace(Cell.formula, "#", i)
  Cell.formula = result

but it also changes the # with #00D700 so I want to get the # which comes after 2nd* sign in cell formula.

但是它也改变了#00D700的#，所以我想要得到#，在单元格公式的第二个*符号之后。

1 个解决方案

#1

Try Replace(Cell.formula, "check#", "check" & i)

尝试更换(细胞。公式，"check#"， "check" & i)