- ©«¤l
- 558
- ¥DÃD
- 58
- ºëµØ
- 0
- ¿n¤À
- 625
- ÂI¦W
- 0
- §@·~¨t²Î
- win8
- ³nÅ骩¥»
- office2013
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- TW
- µù¥U®É¶¡
- 2010-11-22
- ³Ì«áµn¿ý
- 2024-5-18
|
¦^´_ 3# y663258
·s¤â~ ¥u¦³²Â¤èªk~ ¤£¹L´ú¸Õ¬OOKªº~ §A¥i¥H¸Õ¤@¤U
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 = "·s²Ó©úÅé"
.FontStyle = "¼Ð·Ç"
.Size = 12
End With
With Sheet1.Cells(I, J).Characters(Start:=W1 + 1, Length:=W1 + 1 + W2).Font
.Name = "·s²Ó©úÅé"
.FontStyle = "¼Ð·Ç"
.Size = 10
End With
N = N + 1
If Sheet2.Range("B" & N + 2) = "" Then Exit Sub
Next
Next |
|