|
本帖最后由 laoau138 于 2017-5-29 19:18 编辑
用VBA输入图案 不用rept函数还能用什么
Sub lqxs()
Dim i&, n&
[a:a].HorizontalAlignment = xlRight
For i = 1 To 7
n = n + 1
If i < 5 Then
Cells(n, 1) = Application.Rept("M", i)
Else
Cells(n, 1) = Application.Rept("M", 8 - i)
End If
Next
End Sub
String代替, 二者的参数顺序正好相反
- Sub lqxz()
- Dim i&, n&
- [a:a].HorizontalAlignment = xlRight
- For i = 1 To 7
- n = n + 1
- If i < 5 Then
- Cells(n, 1) = String(i, "M")
- Else
- Cells(n, 1) = String(8 - i, "M")
- End If
- Next
- End Sub
复制代码
|
|