摘要:
Sub text()Dim i As IntegerDim txt As StringDim texnkyy As Stringtexnyy = ""txt = "face"For i = 1 To Len(txt) ‘ Len =多少个字符If Not Mid(txt, i, 1) Like "[ 阅读全文
摘要:
Sub test()Dim i As IntegerDim j As Integer For j = 1 To Sheets.Count For i = 100 To 2 Step -1 If Sheets(j).Range("e" & i) = "男" Then Sheets(j).Range(" 阅读全文
摘要:
Sub text()Dim i As IntegerFor i = 2 To Sheets.CountSheet1.Range("b" & i + 8) = Sheets(i).Range("e5")Sheet1.Range("c" & i + 8) = Sheets(i).Range("e6")S 阅读全文
摘要:
Sub gzt()Dim i As IntegerRows("1:1").Select ‘找到a1For i = 1 To 10Selection.Copy ActiveCell.Offset(2, 0).Rows("1:1").EntireRow.Select ’offset(行,列) Entir 阅读全文