想出現N字, 就插入兩行. 以下是插入一行, 唔知點改成插入兩行.
Sub addrowA()
R = 1
For X = 1 To 100
If Cells(R, 1) = "n" Then
R = R + 1
Else
Rows(R + 1).Insert Shift:=xlDown
R = R + 2
End If
Next X
End Sub
收錄日期: 2021-04-13 19:45:21
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20131015000051KK00089