开发者

String concatenation in VBA

开发者 https://www.devze.com 2023-03-10 02:02 出处:网络
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 th

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

精彩评论

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

关注公众号