|
本帖最后由 笑眼晴天 于 2015-6-3 05:09 编辑
函数- =IF(ROW(A1)=COLUMN(A1),A3,IF(ROW(A1)+COLUMN(A1)=6,A3,""))
复制代码 练习一- Sub test1()
- Dim irow As Long, icol As Long
- For irow = 1 To 5
- For icol = 1 To 5
- If irow = icol Or irow + icol = 6 Then '如果行列相等或者行列的结果等于6,单元格的数等于相应数据源中的数
- Cells(irow + 2, icol + 18) = Cells(irow + 2, icol)
- End If
- Next icol
- Next irow
- End Sub
复制代码 附加题- Sub test2()
- Dim irow As Long, icol As Long, prt As Variant
- For irow = 1 To 5
- prt = "" '初始化prt
- For icol = 1 To 5
- If irow = icol Or irow + icol = 6 Then '如果行列相同或者行列和等于6,则prt“*”
- prt = prt & "*"
- Else
- prt = prt & " " '不满足上述条件,prt等于空格
- End If
- Next icol
- Debug.Print prt '打印 prt
- Next irow
- End Sub
复制代码 |
评分
-
查看全部评分
|