星期四, 九月 21, 2006

tips:遍历(Iterator)Excel Range的数据。

方法一:
For i = 1 To rng.row
For j=1 to rng.column
cells(i,j).value=??.
Next

counter = 1
For Each cell In rng
Cells(21, counter).Value = cell.Value
counter = counter + 1
Next