我打左以下code:
Sub 按鈕1_Click()
Dim i As Integer
For i = 5 To 45
If Cells(i, "A") <> "" Then
Cells(i, "B") = Cells(i, "A")
Else
End If
Next i
End Sub
但係呢個只可以係同一張sheet做
我想問, 如果我想
If [Sheet1]Cells(i, "A") <> "" Then
[Sheet2]Cells(i, "B") = [Sheet1]Cells(i, "A")
咁應該要點打?
thanks~