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
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这个我知道,可是得到的是一个数字 我要的是一个公式:(
Sub gg() 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这个可以实现功能你要的.
Selection.FormulaR1C1 = "=sheet" & a & "!RC[" & (10 - a) & "]"引号太多,出来都是红色的:(
For i = 1 To Sheets.Count
Set b = Sheets(1).Cells(i, 3)
b = Sheets(i).Range("k10")
Next 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这个可以实现功能你要的.