N = 0
For I = 1 To 2000
For J = 1 To 6
Sheet1.Cells(I, J) = Sheet2.Range("B" & N + 2) & Chr(10) & Sheet2.Range("C" & N + 2)
W1 = Len(Sheet2.Range("B" & N + 1))
W2 = Len(Sheet2.Range("C" & N + 1))
With Sheet1.Cells(I, J).Characters(Start:=1, Length:=W1).Font
.Name = "新細明體"
.FontStyle = "標準"
.Size = 12
End With
With Sheet1.Cells(I, J).Characters(Start:=W1 + 1, Length:=W1 + 1 + W2).Font
.Name = "新細明體"
.FontStyle = "標準"
.Size = 10
End With
N = N + 1
If Sheet2.Range("B" & N + 2) = "" Then Exit Sub
Next
Next作者: Hsieh 時間: 2011-1-20 16:15