`
阅: 2643 | 回: 0
加法表.99口诀 公式与函数 , 编号:0800 快速回复
发表于2017/3/3 15:24:06 楼主 
头像 等级:初学者
积分:3
财富值:0.2
身份:普通用户

方法1:

Sub ppplll()
Dim m As Integer, N As Integer
For m = 1 To 9
For N = 1 To 9
If N >= m Then
ActiveSheet.Cells(N, m) = m & "+" & N & "=" & m + N
End If
Next N
Next m
End Sub

-----------------------

方法2

Sub Plus()
Dim m As Integer, N As Integer
For m = 1 To 9
For N = m To 9
ActiveSheet.Cells(N, m).Value = m & "+" & N & "=" & m + N
Next N
Next m
End Sub

----------------

换方向

Sub aaaaa()
Dim m As Integer, n As Integer
For m = 9 To 1 Step -1
For n = 9 To m Step -1
ActiveSheet.Cells(10 - n, 10 - m).Value = m & "*" & n & "=" & m * n
Next n
Next m
End Sub

Fish...in the sky

快速回复

目前不允许游客发表,请 登录 注册 后再发贴。