比如我想让sheet1里一列的值分别等于sheet2,sheet3,sheet4....中Range("k10")的值For i = 1 To 10
Sheet1.Range("c" & i).Select
ActiveCell.FormulaR1C1 = "=sheet&i!RC[10-i]"
Next
其中"=sheet&i!RC[10-i]"就有问题,该怎么办呢?
Sheet1.Range("c" & i).Select
ActiveCell.FormulaR1C1 = "=sheet&i!RC[10-i]"
Next
其中"=sheet&i!RC[10-i]"就有问题,该怎么办呢?
Sheet1.Range("c" & i).Select
'ActiveCell.FormulaR1C1 = "=sheet&i!RC[10-i]"
ActiveCell.FormulaR1C1 = "=sheet&i!RC[" & (10 - i) & "]"
Next
http://community.csdn.net/Expert/topic/3494/3494373.xml?temp=.595669可是
For i = 1 To 10
Sheet1.Range("c" & i).Select
'ActiveCell.FormulaR1C1 = "=sheet&i!RC[10-i]"
ActiveCell.FormulaR1C1 = "=sheet&i!RC[" & (10 - i) & "]"
Next这段你编译能过>?
改一下:
ActiveCell.FormulaR1C1 = "=sheet"& i &"!RC[" & (10 - i) & "]"不过我得说,楼主除了要好问之外,如能更用脑会更好。
改一下:
ActiveCell.FormulaR1C1 = "=sheet"& i &"!RC[" & (10 - i) & "]"这个更加不行,是红的饿
For i = 1 To Sheets.Count
Set b = Sheets(1).Cells(i, 1)
b = Sheets(i).Range("k10")
Next i这是我的换位思考.为什么非要用上面的这个公式呢
Dim i%, b As Range
For i = 1 To Sheets.Count
Set b = Sheets(1).Cells(i, 3)
b = Sheets(i).Range("k10")
Next i
下面的语句只能是VB\VBA调用:
ActiveCell.FormulaR1C1 = "=sheet"& i &"!RC[" & (10 - i) & "]"
谢谢指教!!
For i = 1 To Sheets.Count
Set b = Sheets(1).Cells(i, 3)
b = Sheets(i).Range("k10")
Next i
是我的换位思考.为什么非要用上面的这个公式呢?
---------------------------------------------我的确要公式,不要数字,因为如果其他表中的数字改动后,前面表中的数也要相应改动
,这个只有公式可以作到啊!!!
Dim a%
For a = 1 To Sheets.Count
Sheets(1).Cells(a, 3).Select
Selection.FormulaR1C1 = "=sheet" & a & "!RC[" & (10 - a) & "]"
Next a
End Sub这个可以实现功能你要的.
Dim a%
For a = 1 To Sheets.Count
Sheets(1).Cells(a, 3).Select
Selection.FormulaR1C1 = "=sheet" & a & "!RC[" & (10 - a) & "]"
Next a
End Sub这个可以实现功能你要的.---------------------------------
不行不行,通不过通不过!
sheet2.cells(2,3)=sheet3.cells(10,11)
.
.
.
剩下的不用写了吧?:)