下面是我的代码
SheetName = ActiveCell.Previous.Value
ActiveCell.FormulaR1C1 = "=" & SheetName & "!W4"
结果:=SheetName!'W4'w4左右则么会有单引号的呢
如果可以不要呢
谢谢!
SheetName = ActiveCell.Previous.Value
ActiveCell.FormulaR1C1 = "=" & SheetName & "!W4"
结果:=SheetName!'W4'w4左右则么会有单引号的呢
如果可以不要呢
谢谢!
可是在单元格里看到的公式就不对了,W4左右多了单引号
http://download.csdn.net/source/2346022
SheetName = ActiveCell.Previous.Value
ActiveCell.FormulaLocal = "=" & SheetName & "!w4"
为什么呢?
ActiveCell.FormulaR1C1 = "=" & SheetName & "!RC[17]"