开发者

String concatenation in VBA

I have a formula (without the preceding = sign) in a cell, and I want to copy it to a diff cell and add the preceding = sign. I need to do this in a macro and I also have to use absolute numbers of the cells and not relativ开发者_开发知识库e references. How do I do it?


With ThisWorkbook.Sheets("Sheet1")
  .Range("A1").Formula = "=" & .Range("B1").Value
End With
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜