VBA巨集使用方法 重點Cells(y,x)
'九九乘法表
Sub test()
For i = 1 To 9
Cells(i + 1, 1) = i
Cells(1, i + 1) = i
Next i
For i = 1 To 9
For j = 1 To 9
Cells(i + 1, j + 1) = i * j
Next j
Next i
End Sub
更深入的VBA巨集使用
http://blog.xuite.net/crdotlin/excel/9092240-%E7%94%A8Range%EF%BC%9F%E7%94%A8Cells%EF%BC%9F
不同表的處理
http://www.cc.ntu.edu.tw/chinese/epaper/0019/20111220_1910.html